Append query macro help!

[vvwilson]

I am using 10 append queries to create a table and am finding a need
to manipulate the criteria for the queries (i.e. the day) is there a
way for me to create a macro that will allow me to update criteria for
each query all at once?

 

[Steve Schapel]

VV,

The normal way to supply date criteria for a query is to have an unbound
textbox on a form which will be open at the time that the query is run,
and enter the criteria date in there, and then reference this textbox in
the query criteria using syntax such as
[Forms]![NaemOfForm]![NameOfTextbox]. If you did that, you could
presumably have all 10 append queries relating to the same criteria
textbox, so you only have to enter it once.