Knicks
I'm not sure where the query is getting it's "State" and "City" and "Profession" criteria, but have you consider driving the process from a form?
If you drive it from a form, what you want is easier to do, because then you don't have to make a bunch of different queries, or have parameters to complete each time.
Here's how you would do what I am suggesting.
1. Create an unbound form. Let's call it frmSelectCriteria. The form would have 3 text boxes. Let's call one txtCity, another txtState, and the third txtProfession. You would also have a command button that, when pressed, would either Preview or Print the report.
2. In your query, in criteria row for the City column, put
Forms!frmSelectCriteria!txtCity
In the criteria row for the State column, put
Forms!frmSelectCriteria!txtState
In the criteria row for the Profession, put
Forms!frmSelectCriteria!txtProfession
3. In your Report Header, that has its Record Source as the query you are using, put an unbound text box that has something such as the following expression...
= "This report covers all people in the city of " & Forms!frmSelectCriteria!txtCity & ", " & Forms!frmSelectCriteria!txtState & " whose profession is " & Forms!frmSelectCriteria!txtProfession
You only need to build this form once. And you only need 1 query and 1 report to run this process.
You start by opening the form, enter the criteria in the 3 text boxes, press the command button and it's done.
Tom