queries picking up and calculating dates

[donnycarr]

I have set up 12 or so queries. Within these are some date criteria whereby the query picks up a date from a form ( through a text box on the form, formatted to Date/Time and with an Input Mask where the user inputs a certain date).

I now want the query to work out the 4 week period before this date and use that criteria to select records from the database.

Also…

When my macro runs these 12 queries it asks the user to enter the date into the input mask for every query, Is it possible to just enter the date once for all 12?

Any help suggestions would be much appreciated,

..Donny

 

[llkhoutx]

the criteria for your query is

<= date() and <= (date() - 28)

Establish a text box on your form with the based date, example "txtDate" then use the expression builder to build a reference to that text box in the criteria for each of your 12 queries as above.