Question: 1 . Use design view to create a parameter query that will show records based on the Status that the user enters. Show the following

1. Use design view to create a parameter query that will show records based on the Status that the user enters. Show the following fields from the Member table: FirstName, LastName, City, Phone, and MembershipStatus. Enter the parameter that will prompt the user to enter the member status when the query is run. Save the query as Status Parameter. Modify the design view to show all records if the user does not enter a value for the MembershipStatus field parameter.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!