Stangely not working HELP!

  • Thread starter TehSparrow via AccessMonster.com
  • Start date
T

TehSparrow via AccessMonster.com

i need a report to only show results after the current day, so in the
criteria, i entered >Now() and it seems to work for the query, but i still
get the unwanted results in my report, Am i doing something wrong?

HELP!!!!!!!!!!!!!!!!!!!!!

Cheers

Sparrow
 
B

BruceM

Random capitalization in your question makes it more difficult to read, and
therefore perhaps less likely to draw a response.
Do you mean you want to see the day's results at the end of the day? "After
the current day" is the future, as is >Now(). This could be fine if you are
looking for due dates or something like that, but since you have not
explained your "unwanted results" it is hard to know how to fix them. You
could try =Date() as the criteria if you are looking for today's records.
 
J

John Vinson

i need a report to only show results after the current day, so in the
criteria, i entered >Now() and it seems to work for the query, but i still
get the unwanted results in my report, Am i doing something wrong?
Click to expand...

Now() does not return the current date. It returns the current date
AND TIME, accurate to microseconds - so > Now() means "anytime later
today or any time in the future".

To get "after the current day" you need to use > Date() instead.

If that's not it, please post the SQL view of your query, and some
sample "unwanted results"; it's more than a bit difficult to tell what
you're doing wrong if you don't tell us what you're doing!

John W. Vinson[MVP]
 
Top