Search results

Thank you AlienRay, that's very helpful. I was thinking I might have to put false or empty records in to generate the schedule in Access and kind of blind-sided myself. The separate table for all dates is a good workable solution.

Hi, thanks for this reply. Unfortunately I don't think I understand or I haven't explained what I'm after very well. Firstly, I'm looking at records in a date range rather than a single date and so would need to combine the range of records that exist with instructions to show them within the...

I've devised a report for a touring theatre company for their shows list. I use a date range query to target different parts of their touring. I'd like for them to be able to see blanks in the report where there is no data for given dates(basically what gaps are left), for booking purposes. How...