Selecting dates

[Crispie38]

Quick one for you geniuses out there!

I would like a command button to print records from a select query displaying dates for the past 2 days but not for todays date.
e.g. today is the 29th, I want to print records for the 27th & 28th.

Data is being recorded hourly and kept for 2 months so there will be new and old data that I don't want printed.

Thanks for the help!!

 

[ColinEssex]

In the criteria of the date field put this

Between Date() - 2 and Date() - 1

The -2 will give you 2 days ago and the -1 is yesterday

Col