View Single Post
  #1  
Old May 24th, 2010, 03:35 AM posted to microsoft.public.access.reports
SCS
external usenet poster
 
Posts: 3
Default Grouped/Sorted Report by Month

I have a fairly simple access database. I've created a report grouped by
Category and Month... with a total per month. My problem is that the
months with no total don't show on the report. Is there a way to make the
month show with a zero total?

ie.
January - 24 orders
February - 30 orders
March - 0 orders
April - 28 orders
********This is what I'd like to see ... each month listed. Currently,
March doesn't show at all on my report.

Any help would be appreciated.

Ads