MakeTable QRY output (need zero's)

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

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Maxwell" wrote in message
...
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