Create a New Select Query:
rptOverdueSQ
A new Query will calculate the
difference between the DateRented and the current date. Please
create a new Select Query and add the following Tables.
1. Try it: Create a Query
Go to Create ->Queries ->Query Design.
You will be
prompted by the Show Table.
Select a
Table: tblMovieRented.
Click Add.
Select a
Table: tblMovies.
Click Add.
Select a
Table: tblRentalPrices.
Click Add.
Close
the Show Table Window.
Keep
going...