Automate query criteria 1

[gwoman]

I have a macro that runs a series of queries that create and append data to a table. In these queries there is a field EFTV_DATE that has a criteria of #12/1/(previous year)#. These produce a year end report and are always run in January ... so for instance this being 2009 the criteria would be #12/1/2008#. Right now I have to go into a mass of different queries and manually change the year in the criteria. Is there anyway to automate this in the query? So next year when I run these it will look at Date() and know that is needs to be #12/1/2009#.

Thanks much ...

gwoman

 

[PHV]

DateSerial(Year(Date())-1,1,12)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[gwoman]

Excellent ... it works perfectly!
You totally rock PHV!!!

Have a good one!

gwoman