Access 2000: Date Function as Criteria for Query.

[Wozza]

Is it possible to enter criteria in a query for the current month or last month?
I can set up the query to ask me for the first and last dates (inclusive) but I am wanting to produce lots of queries that a macro runs - so I do not want to repeatedly enter these dates.

 

[mrf1xa]

If I've understood correctlty, it may help to have the start and end dates entered into text boxes on a form, and point the queries to them eg Between Forms![yourform]![start] And forms![yourform]![finish].

As long as the form stays open while the queries run they can reference these dates as many times as necessary, and you only have to key them once.

HTH Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....