Calculate the Date Difference, part one
You may have noticed that the Front Row Video database is incomplete. We
have a query that calculates the date that a movie was rented. However, we
DON”T have the date the movies were returned. Our query is based on the
Date Difference (DateDif) between the rental date and today’s date.
You can search high and low through the tables, forms and queries: our
database does not record the return date. Here’s what you need to do:
Open the sample database: Front Row
Videos Intermediate Report Design.mdb Unhide the database window so we can
work with the tables and forms.
Open tblMovieRented and add a new field for DateRetuned. Change the
field properties for Format and Input Masks so that they match the other
Date field in this table. Add a default value of =Now() Save your changes.
Add the DateReturned control to the ReceiptSubform. Make sure the
DateReturned column is visible in the datasheet view. Save this form.
more on the next page
Level 16: Practice
