Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 More

Don't Call Us...

A parameter query asks the user to fill in the blanks. You have many, many customers in your database. You could use a parameter query to prompt you for the customer's name, then print out a report for that customer.

 

This part of the database design begins by making copies of a report and query that you already have.

 

Make a copy of the report: rptOverdueVideos

 

Name it rptCustomerRentals.

 

Make a copy of the query: rptCustomerReceiptSQ

 

Name it rptCustomerRentalsSQ.

Home ->View ->Report Design
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 4. Creating and modifying queries 

  4.2. Modify queries   4.2.2.   Add criteria to queries: Parameters