View Single Post
  #1  
Old May 24th, 2010, 03:45 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Sorting/Grouping ... Show a month if Zero (Access 2007)

SCS wrote:

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.


I tried to answer your other post with the same question
yesterday.

--
Marsh
MVP [MS Access]