NZ functions in underlying queries for reports

[TGHockett]

I have tried to use the NZ funtion to clear up the null problem in query totals for reports (it works fine for the first field defined then doesn't work for the other fields). Have also tried basing the NZ function on the direct-table querie and another on which the report is based on an intermediate query --- any ideas will be appreciated (currently exporting the query data sheet data to Excel for now)

What am I missing?
TGH

 

[gino]

for nulls i sometimes use the iif function.
for example:

iif([yourfield]=0,0,calculation if not null)

it works very well for me.

 

[TGHockett]

Thanks for the idea, Gino, and I will double check the formula, Pat. Actually an Access Guru from another dept. setup the initial function calc. and now that I think about it he had to use the tablename as well as the field in something like..

NZ([tablename]![fieldname],0]

Not sure why he used the tablename since its a groupby/sum query ... but will tryout your ideas. Thanks again.