Friday 28 February 2014

Create a parameter query based on the Customer table that prompts for customers in a specific state. Do not just make a select query. A parameter is different. Display the CustomerNum, CustomerName, City, and State fields

  1. Create a parameter query based on the Customer table that prompts for customers in a specific state. Do not just make a select query. A parameter is different. Display the CustomerNum, CustomerName, City, and State fields.

Save the query as #10 States YourName. Run the query using a parameter value of OH. You will see only 4 Oh records.

No comments:

Post a Comment