Calculation in Query not working

[gilescis]

I have a query that needs a calculation field for a report.
This is my field in the query.

Gross: [TBLinvamt]-[TBLinvqty]*67-[TBLfrtamt]-[TBLocamt]

Here lies the problem

example: 3210.81 - 25 * 67 - 0.00 - 0.00

If the frtamt and ocamt fields are 0.00 then my Gross field does not display any value

But if i put 1000.00 for frtamt and 500.00 for ocamt then the gross field returns a value.

Help is greatly appreciated

 

[boblarson]

Are you sure that they are zero and not NULL? Nulls won't return values, but zero will. Use the NZ function to try.

Gross: Nz([TBLinvamt],0)-Nz([TBLinvqty],0)*67-Nz([TBLfrtamt],0)-Nz([TBLocamt],0)