A
Amy E. Baggott
I have a report and an update query that both use an existing query as a data
source. What I want to do is have the existing query filter based on the
type of group the user wants. For instance, the user can choose to run the
report for all records, a specified record by ID number, or a range of
records by a point score. Additionally, there is a secondary selection to
filter for all records with a received date <= a specified deadline date or
to print all records. The update query needs to mark all the records on the
report -- but ONLY those records -- by setting a true/false field to true.
What would be the best way to do this? I was planning to use a dialog box
with option groups to select the options and run the report and the update
query simultaneously. I've done similar things by having multiple copies of
the same query and report with different criteria, but that gets unwieldy,
and I can't help thinking there's a better way to do it.
source. What I want to do is have the existing query filter based on the
type of group the user wants. For instance, the user can choose to run the
report for all records, a specified record by ID number, or a range of
records by a point score. Additionally, there is a secondary selection to
filter for all records with a received date <= a specified deadline date or
to print all records. The update query needs to mark all the records on the
report -- but ONLY those records -- by setting a true/false field to true.
What would be the best way to do this? I was planning to use a dialog box
with option groups to select the options and run the report and the update
query simultaneously. I've done similar things by having multiple copies of
the same query and report with different criteria, but that gets unwieldy,
and I can't help thinking there's a better way to do it.