Date query

bunji

Registered User.
Local time
Today, 23:05
Joined
Apr 26, 2005
Messages
124
Hi Everyone i am trying to run a query that gets the records within a date range, asking the user for a start date and end date. How i think the problem is because the field is date & time.

>= [Please enter first date] <= [Please enter last date]

This seems to produce all the results. I even tried just writing an actual date in the criteria.
 
try the between statement
Between [start] And [end]

HTH

Peter
 
Sorry its that friday feeling blocking messages from my brain!! thanks
 

Users who are viewing this thread

Back
Top Bottom