Display blank entries in a report

[Chad Cameron]

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

 

[Steve]

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 address removed)

 

[KARL DEWEY]

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

 

[john smith]

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