Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

On the Record

A report can be based on a table, or a query. This example will use a query for the record source. This query will be based on the MovieRented table.

 

In order to create a report with names, addresses, movies and prices, you need to add three more tables and link them to the receipt table.

 

Try it: Create a Query

Go to Create->Query Design.

At the Show Table select:

tblCustomers

tblMovieRented

tblMovieTitles

tblRental

 

Who (tblCustomers)

Bought (tblMovieRented)

What (tblMovieTitles)...

Create->Query Design ->Show Table