Leave blank line if no record on date

[Carrion]

I have a report that is referencing a table of reservations. The report sorts by date of reservations. My problem is that if there are no reservations on a date then the report does not list the date. I want it to list the date, but have no records Beneath it. Is this at all possable.

Thanks
trace

 

[dhookom]

You need to have a table/query with all the date values. You can then use the "all dates" table in the report's record source with a join that includes all records from "all dates".

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[vmauro]

You would need to explain more on what fields you have

but you can use a unbound field in the report that has the following or something simular in the data source

IIf([date]Is Null,"No Reservations",[date])

or create a expression in the Qry that drives the report to note if a reservation was made.