Is there a technique to using the same basic query only changing a parameter each time you run it?
Say for instance I am using a query that captures all records from a table with fields:
Name
Position
OfficeSymbol
I then want to be able to run the query to select based upon a parameter with the Name. Another query parameter with the Position and lastly another parameter using the OfficeSymbol.
Currently I have a separate query built for each of these requests, but thinking there is a more efficient use of the query that I am missing.
I also would like to apply the same idea to the multiple reports I have written that each run based upon one of the parameter queries I have built. Seems there must be a way to reduce the number of queries and reports that all collect and display the same basic fields only being limited to the parameter used.
Say for instance I am using a query that captures all records from a table with fields:
Name
Position
OfficeSymbol
I then want to be able to run the query to select based upon a parameter with the Name. Another query parameter with the Position and lastly another parameter using the OfficeSymbol.
Currently I have a separate query built for each of these requests, but thinking there is a more efficient use of the query that I am missing.
I also would like to apply the same idea to the multiple reports I have written that each run based upon one of the parameter queries I have built. Seems there must be a way to reduce the number of queries and reports that all collect and display the same basic fields only being limited to the parameter used.
