Prev: Write Name of Report Query in Report Footer
Next: Using a parameter in a report
From: SCS on 24 May 2010 10:59
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.
From: Marshall Barton on 24 May 2010 10:45
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]
 | 
Pages: 1
Prev: Write Name of Report Query in Report Footer
Next: Using a parameter in a report