date and time qry

Dona

Registered User.
Local time
Today, 23:10
Joined
Jun 27, 2002
Messages
55
How do you query date/time? I have a field with date and time, e.g. 4/2/2004 5:12:33 PM. I want to query all records before 4/2/2004. When I type < 4/2/2004*, I get an error message.

Any suggestions?

Thank you.
 
THANKS KEN

I thought I needed to put the * since I did not know the time. Guess not.

Thanks! Have a great day!
 

Users who are viewing this thread

Back
Top Bottom