[ksroadrunner13]

I have a database running on an SQL server. I have a table in that database named "EventLog". For each event in the event log there is a time/date stamp field called "OpenTimeDate" that consists of a full time and date "MM/DD/YY HH:MM:SS AM" and I'm trying to find a query string that will effectively pull all the records for the last 7 days according to that field. I had one that worked beautifully in Access, but as soon as I upgraded to SQL the query string quit working right. Any help would be GREAT!!!

If you require any more info, please let me know.

Thanks!!!

if your still using the access database, goto the sql view of the query and copy the code from there to your page