Change query with user input

[chancer1967]

My database instructions continue...

"before running the next 4 queries, go into design view and change the date in the criterias as appropriate"

the queries generate an ageing of debtors

for example the criteria are currently:
query1 ">#31-Dec-03#"
query2 ">#30-Nov-03# And <#01-Jan-04#"
query3 ">#31-Oct-03# And <#01-Dec-03#"
query4 "<#01-Nov-03#"

obviously, in a months' time, all the dates will need to be moved forward

what i think i would like is a macro that requests dates from the user then runs the 4 queries

i now know how to get the macro to run the queries
how do i get it to modify them first?


many thanks!

 

[Rich]

scrap the macro and use a form/calendar control to pass the parameters to the queries