Updating criteria in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several queries that pull different records, but often times based on
the same time frame, like the month of January, or last week. Is there a way
I can update the criteria in several queries with a macro or code.
 
Dear Mandango:

If you want to create persistent values for use in queries, a good place to
do this is to store them in a table. Perhaps a table called Parameters with
two columns, ParameterName and ParameterValue. These can be tied into your
query.

A form can be easily created to display and enter all the parameters you
need. An important choice is whether each user or computer has its own set
of parameters to be saved, or if there is to be just on set of parameters
for the whole system.

Tom Ellison
 
Back
Top