R
Rod
You might also be able to suppress that in the query.
Create the calculated field in the query and then use your
criteria to eliminate those lines.
Select fielda, fieldb, fieldc, (fielda + fieldb)*fieldc
from table1
Where ((fielda + fieldb)*fieldc)>0
Create the calculated field in the query and then use your
criteria to eliminate those lines.
Select fielda, fieldb, fieldc, (fielda + fieldb)*fieldc
from table1
Where ((fielda + fieldb)*fieldc)>0