Force a query to show zero

  • Thread starter Thread starter Lesley
  • Start date Start date
L

Lesley

I have a query with 3 columns based on a table - column
one is [Month] which is based on a popup input form,
column 2 is the sum of a field [Cost] and column 3 counts
the number of [Cost] lines that are summed in col 2.
It works fine as long as there is at least one entry for
that month. How can I make it show zeros in columns 2 and
3 if there are no entries that month? Right now it is
empty and effects other queries based on this one.
I tried the Nz function which didn't work and now I'm out
of ideas.
Thanks
 
Does the month show? If not then I suppose you need a non-existant record to
display. Do you have a table that all possible months can be derived from?
 
Back
Top