Automatically change a criteria

[supercharge]

Hello to all the xperts out there,

I have a query with this criteria for Date field:

Where (([tblList].Date)>=#11/1/2005# And ([tblList].Date)<#12/1/2005#))

Is there any quick way, besides creating a form and run the query based on it, to have this criteria updated itself when it's a new month? I've gotten tired of changing it every month.

Thanks in advance

 

[jeremie_ingram]

You could use a query to generate the data into a custom field with the setting of "1/" & Month(Now()) & "/" & Year(Now()).

This would always display 1/curMonth/CurYear

 

[pdx_man]

Where Month([tblList].Date) & Year([tblList].Date) = Month(Date()) & Year(Date())

Using the fieldname Date is poor naming convention as it is also the reserved function to get the system date. I would suggest changing that.