Date criteria

[Sport]

When I try to use the following as the parameter for a query I get an error.

Between #date()# and #date()# -1

Basically I'm trying to automate the report to pull up the last 24hrs.

 

[Fons Ponsioen]

Hi Sport.
Try using Between now() and now()-1
Hope this helps
Fons

 

[Sport]

I had thought of that, but doesn't that take time into account aswell?

 

[Fons Ponsioen]

I have tried that on a few tables I have and I think if
you set the format to short date, it works.
Take care.
Fons