Display blank entries in a report

  • Thread starter Thread starter Chad Cameron
  • Start date Start date
C

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
 
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)
 
Chad Cameron said:
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
Click to expand...
 
Back
Top