In a report, limit data to 90 days before today.

[Ed Mattison]

I want to create a report that has an "opendate" field and where the opendate field is within the last 90 days. I won't bore you with my unsuccessful efforts, but I thought under Report Properties that I could write something on the On Open line that would work. So far so bad. Thanks Ed

[aytee111]

In the RecordSource for the report, create a query with that as a criteria: OpenDate >Date()-91

[jwhite]

In the Recordsource for your report you would include the criteria: WHERE [opendate] Between DateAdd("d",-90,Date()) And Date()

"Air Code"...