How can I create a report with a screen that pops up where I will need to enter a start date and end date as these dates will have to change each week.

Thanks,
Scott

Do you need the dates to appear on the report?

Yes, I would like to have the dates print on the report. The dates would actually be the Headings for some of the columns.

The way I do this is to create a small pup up form where you enter these dates and then use them as criteria in the reports underlying query and you can also use them in the report as the source to populate some unbound 'date' text boxes...

See this:

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=12200&d=1137070020