Append query macro help!

  • Thread starter Thread starter vvwilson
  • Start date Start date
V

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?
 
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.
 
Back
Top