MakeTable QRY output (need zero's)

[Maxwell]

Hello,

I am having difficulty with the following...Hope you can
follow what I did....

Created a 'MakeTable' query from a Crosstab query to give
me sales for an item I sold.
Some weeks did not sell anything.
In those empty weeks, the output shows a "blank" cell in
the table from the maketable query. I need it to give me
a zero instead of a blank.

How do I force a zero so that it will show up in the table?

Please advise

 

[Douglas J. Steele]

Use the Nz function to convert the Null values to zeroes.