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

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