Show Date Even When Record Is Missing

[doulostheou]

I am creating a report that will print a list of everyone who has requested off in a given week. The reported will be sorted by date. I have set a paramater to limit the records to one week; but I want the day to appear on a report, even if there are no records on that day.

For instance, if no one requests off 6/5, I want the report to show 6/4 with a list of people off, 6/5 with no one off, and then 6/6 with a list of people off.

I'm not sure how to go about this.

 

[RV]

A quick suggestion:

If your report is based on a query, you could use an UNION query.
Use the first SELECT statement to retrieve all dates with requests.
Use the second SELECT statement to retrieve all dates with NO requests.

HTH,

RV

 

[doulostheou]

How would you retrieve all dates with no records?

 

[Rich]

You'll need a table to store dates irrespective of time off requests.