Using Time Criteria

  • Thread starter Thread starter Anita Taylor
  • Start date Start date
A

Anita Taylor

I am querying against an SQL database using Access 2000.
The table against which I'm querying has two date/time
fields: Open Date and Closed Date.

I have a parameter query set up to ask for an Open Date. I
need to have this query return results where the Closed
Date is greater than 24 hours past the Open Date.

I cannot begin to figure this out and would greatly
appreciate any help!
 
Back
Top