Can I ask the user for data when s/he runs a report?

Sorry for what is probably a very newbie question. I have lots of coding experience but almost no database experience. I am helping a non-profit with their existing ODB. They have six reports that are completely identical except each has a different filter (“Clients”.“Route” = ‘value’). Each of the six reports has a different hard-coded ‘value’ but they are otherwise identical. This is a little bit of a maintenance nightmare! Is there any way I can start report execution by saying “What route?” and using the user’s response as the value in the filter?

Thanks much!

Create a parameter query like

SELECT "this", "that" FROM "somewhere" WHERE "Date Column" = :Please_Enter_Report_Date

and make it the report source.

That did it! Thanks!

Charles

~WRD0000.jpg