Filtering dates

  • Thread starter Thread starter Hendrix10
  • Start date Start date
H

Hendrix10

I am trying to run a query that pulls out certain dates (i.e 4/16/08
and 4/23/08) but I keep getting an error message.

what should I be putting in the criteria line?
 
I am trying to run a query that pulls out certain dates (i.e 4/16/08
and 4/23/08) but I keep getting an error message.

what should I be putting in the criteria line?
Click to expand...

How would anyone of us know?
What is the error message?
Exactly what is the query's SQL?
Copy it and paste it into a reply message.
 
I am trying to run a query that pulls out certain dates (i.e 4/16/08
and 4/23/08) but I keep getting an error message.

what should I be putting in the criteria line?
Click to expand...

PURELY guessing here, since you have posted essentially no details:

IN (#4/16/08#, #4/23/08#)

This assumes that you have a date/time field with pure dates (no time
component) and that you don't want a parameter query to prompt you.
 
Back
Top