rptMovieRentedSQ: Fields

4. Try it: Add Fields to the Query

Add the following Fields to the QBE Grid:

From tblMovieRented:

ReceiptID

DateRented

 

From tblMovies:

Movie

 

From tblRentalPrices:

Price

Description

 

Do This, Now: Save the Query

Go to File->Save.

Enter the name: rptMovieRentedSQ.

 

Keep going...

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Add Fields to a Query

Query Tools ->Design