data query

[drsalvas]

I have a table with a column formatted mm/dd/yyyy 00:00:00 PM, I am trying to run a query to show only records that are put in after a certain time, ex) only show records after 11/27/2002 4:30:00 PM. Anyone know how to setup this search criteria??

I received a reply from Corticus on a different Forum but he directed me here.

He gave me #11/27/2002 4:30:00 PM# which works to pull up only the matching records. Is there anyway to pull up all records AFTER 4:30 PM??

Thanks for any help!!

Dan

 

[Russell Hauf]

How about

> #11/27/2002 4:30:00 PM# ?

HTH,

Russell

 

[drsalvas]

Works like a gem!!

Thanks a bunch

Dan

 

[drsalvas]

That works great!!

Is there anyway I can run this query with different dates?

I.E. 12/1/2002 4:30:00 PM and 12/2/2002 4:35:00 PM AFTER 4:00:00 PM??

I tried using wildcards but it wont take any of them.

Thanks

 

[drsalvas]

Actually I just figured it out, take out the date!!

Who'd of thought!!!!!

Thanks again for all your help.

Dan