C
cs
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!
pulling up all the entries older that 9/14/07???? Please help!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
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.
was used to populate it)?
If so, use <= #9/15/2007# instead.
K
KARL DEWEY
What other criteria are you using? Try dropping the other criteria.
C
cs
There is no time in the criteria. I am using <=#9/14/2007# as indicated.
D
Douglas J. Steele
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#.
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#.
C
cs
Perhaps that was the problem. It's working OK now - THANKS!