MakeTable QRY output (need zero's)

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

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
 
Back
Top