MS Access criteria filter problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the criteria <=#9/14/2007# in one of the columns and it's not
pulling up all the entries older that 9/14/07???? Please help!
 
Does your date field also have time in it (likely because the Now() function
was used to populate it)?

If so, use <= #9/15/2007# instead.
 
There is no time in the criteria. I am using <=#9/14/2007# as indicated.
 
I didn't say anything about the criteria using time. I asked whether the
data field on which you're filtering includes time.

If it does, then any entries during the day of 14 Sept, 2007 will not show
up, as it will be greater than #9/14/2007#.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Date criteria in a query 4
Access Counting records based on multiple age bracket and output to tabulated report 0
MS Access query filter problem 1
Period End Dates Table ... How to Link? 3
Access 2007 Date field shows Now instead of Date 4
excluding 12:00:00 AM from query results 4
Having a problem with calculating medians in access 1

Back
Top