Hi All,

I have a report that shows me statistics for each day on a monthly basis.
At the end of the month when I view my report it looks like the following

Dec 1, 2009
A = 53
B = 53

Dec 2, 2009
A=53

Dec 3, 2009
A = 53
B = 53

Dec 5, 2009
B = 53

Is there a way to setup my report so that it prints out all the days (Dec 4
is missing) and have no records under it. That way I can see that it is
blank. I find it a pain to look for missing dates, I would rather look for
dates with no entries.

Thanks
Chad

It appears that you are only displaying the dates that are in the
recordsource (table or query) of your report. You need to change the
recordsource to display all dates in the reporting month irregardless if the
date is in the existing data.

Steve
(E-Mail Removed)


"Chad Cameron" <(E-Mail Removed) remove NOT> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I have a report that shows me statistics for each day on a monthly basis.
> At the end of the month when I view my report it looks like the following
>
> Dec 1, 2009
> A = 53
> B = 53
>
> Dec 2, 2009
> A=53
>
> Dec 3, 2009
> A = 53
> B = 53
>
> Dec 5, 2009
> B = 53
>
> Is there a way to setup my report so that it prints out all the days (Dec
> 4 is missing) and have no records under it. That way I can see that it is
> blank. I find it a pain to look for missing dates, I would rather look
> for dates with no entries.
>
> Thanks
> Chad
>

Post the SQL of the query or source for the report.

--
Build a little, test a little.


"Chad Cameron" wrote:

> Hi All,
>
> I have a report that shows me statistics for each day on a monthly basis.
> At the end of the month when I view my report it looks like the following
>
> Dec 1, 2009
> A = 53
> B = 53
>
> Dec 2, 2009
> A=53
>
> Dec 3, 2009
> A = 53
> B = 53
>
> Dec 5, 2009
> B = 53
>
> Is there a way to setup my report so that it prints out all the days (Dec 4
> is missing) and have no records under it. That way I can see that it is
> blank. I find it a pain to look for missing dates, I would rather look for
> dates with no entries.
>
> Thanks
> Chad
>
>
> .
>

"Chad Cameron" <(E-Mail Removed) remove NOT> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I have a report that shows me statistics for each day on a monthly basis.
> At the end of the month when I view my report it looks like the following
>
> Dec 1, 2009
> A = 53
> B = 53
>
> Dec 2, 2009
> A=53
>
> Dec 3, 2009
> A = 53
> B = 53
>
> Dec 5, 2009
> B = 53
>
> Is there a way to setup my report so that it prints out all the days (Dec
> 4 is missing) and have no records under it. That way I can see that it is
> blank. I find it a pain to look for missing dates, I would rather look
> for dates with no entries.
>
> Thanks
> Chad
>