How do I show each month as group when no data exists for the mont

[Wallene]

I need a report showing the data for each month, but I want to show every
month, even when there is no data for that month.

 

[Jeff Boyce]

Look into cross-tab reports.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[AJ Moroz]

- One solution is to create a lookup table holding the 12 months
(PK=[MonthNumber], ex: 1, 2, 3; can also have a field called [MonthName] for
display purposes).
- Use the lookup table in the report query using an Outer Join, so all
months are displayed even if no data exists.
- A Select query or Crosstab query can be used for the report.