Show all 12 months in query

[Brian62]

I want to show all 12 months even though they are not present yet in the table. January, February.....

Here is the script I am using:

Month: Format([Date],"mmmm")

It only shows the months that are in the table. I need to show all months even though the field is empty. Is there another way in the report to show each month but has no data to fill it. Show 0 in the cell if empty?

Can this be done in a report to show 0 if table has no data for that month?

On the form I show all twelve months. If the cell is empty I get an error because there is no data to retrieve for that month.

DB attached. Thx!

 

[Galaxiom]

Try the Nz function.
http://office.microsoft.com/en-us/access/HA012288901033.aspx

 

[namliam]

NZ wont work for multiple values

I uploaded a database sample a while ago to calculate all dummy months, you can probably addapt it to suite your needs: