 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / September 2007MS Access criteria filter problem
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.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) >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! What other criteria are you using? Try dropping the other criteria. SignatureKARL DEWEY Build a little - Test a little > 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! There is no time in the criteria. I am using <=#9/14/2007# as indicated. > 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! 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#. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > There is no time in the criteria. I am using <=#9/14/2007# as indicated. > >> 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! Perhaps that was the problem. It's working OK now - THANKS! > I didn't say anything about the criteria using time. I asked whether the > data field on which you're filtering includes time. [quoted text clipped - 6 lines] > >> 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! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.