Calculating blanks

[ECEK]

I have a query that has a list of unique references linked to two querys.
The querys are monetary values that append to a table. The default value in the table is zero and set to currency however if there is not value in the query it registers as a blank. I need to do calculations from this table but I am unable to do so seeing as if there is no value in the query it is just blank in the table.

I hope this is clear?

Help ?

 

[ECEK]

Do I take it that I should use a If Null in my subsequent calculations

 

[arnelgp]

Use nz(field, 0) to convert the blanks to 0 then you can calcu.

 

[ECEK]

Thanks Arnie
I just used is Null in the append query