View Single Post
  #2  
Old May 24th, 2010, 03:59 PM posted to microsoft.public.access.reports
SCS
external usenet poster
 
Posts: 3
Default Sorting/Grouping ... Show a month if Zero (Access 2007)

I've created a fairly simple database. Mostly it has an order date, and the
number of items ordered. I've created a report that will show order counts
by month (by grouping/sorting by order date). My problem is this ... if
the order count for a month is Zero ... then the month doesn't show on the
list at all. Is there a way to make it show even if 0?

ie:
I want to see it like this ......
January 27
February 38
March 0
April 18

Currently, March doesn't show at all .... just Jan/Feb/Apr. I want to see
every month no matter the count.

Any help would be appreciated.