Querry Criteria

[Guest]

I use Access 2000 to store data, (I created forms to intput the data into
various tables, and Queries to generate various reports, both on a daily and
monthly basis, Currently, I have to go into my queries each morning, and at
the begining of each month, in the design wiew and update the criteria of
each query to filter out only the records having the current date, to
generate daily reports, ex... (=#12/25/05#) or , ex..., (>#12/31/2004#). Can
you show me the proper contex that would automatically update the criteria
for my queries? Any light you could shead on this problem would be
appreciated.

 

[Dan Artuso]

Hi,
If you mean you want the criteria to be the current date, use:
=Date()