Question: Because customers live in different states, it is often advantageous to create a query where you can change one criteria using a parameter query.
Because customers live in different states, it is often advantageous to create a query where you can change one criteria using a parameter query. Open the StatesParameter query in Design View. Add parameter criteria to the State field to replace the current "FL" criteria. The new parameter criteria should prompt the user with Enter desired state as the text. Save the changes to the query. View the query in Datasheet View. Enter PA when prompted. Confirm that 8 records appear in the query results then close the query, saving if necessary.
Step by Step Solution
3.37 Rating (153 Votes )
There are 3 Steps involved in it
Based on the instructions in the image it looks like you are using Microsoft Access and are tasked t... View full answer
Get step-by-step solutions from verified subject matter experts
