Automating a Criteria??? 1

[RookieDBO]

Is it possible in Access to automate a criteria in a field? I'm hoping it would be, especially if the process of the criteria is the same but not necessarily the same characters every time I run the query. For instance, I've got a field in a query that is called "Inventory End of Date" long for "Invn_End0fDate". I run this query plus others everyweek to track specific products in my company. That date must be yesterday's date in order to extract current quantity. I would like to automate the criteria by using the logic of "go back one day from today's date". Can this be done? How and Where?

Thanks,
RookieDBO

 

[Databaseguy]

Simple. In the criteria field, type:

=date()-1

Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[RookieDBO]

Great! It worked. What about a criteria that increments by one every week? For instance, I've got field that's called "Week #" and my criteria for this week would be "40". That increments one next week. So it would be "41". How can I automate that?

Thanks,
RookieDBO

 

[tempclerk]

=Datepart("ww",Date())