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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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