Problem with null or empty table

[DanSmith]

Hello,

I have the following problem:

I have a make table query that sum a total amount in order to have only the total in the table field.

However, when the total is 0.00, the make table query says "you are about to pos 0 rows" instead of postin 1 row with 0.00.

How can I set the query in order to have a 0 in the table when the total is 0 instead of having nothing posted ?

I have tried the is null, is empty, is missing, nz and nothing seems to work.

Thanks for your help.

Cheers!
Dan

 

[KenHigg]

Could you simply make this an append query?

???