rptOverdueSQ: Fields

3. Try it: Add Fields to the Query

Add the following Fields to the QBE Grid:

 

From tblMovieRented:

ReceiptID

CustomerID

DateRented

 

From tblMovies:

Movie

 

From tblRentalPrices:

Price

Description

 

Do This, Now: Save the Query

Go to File->Save.

Enter the name: rptOverdueSQ.

 

Keep going...

Query Tools ->Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.2. Manage source tables and relationships