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
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
