|
Before
You Forget: Save the Update Query. Go to
File->Save. Enter a
Name: MovieRentalPriceUQ Where UQ
means Update Query. Close
the Query. The Action
Query changed the data in tblMovies. All of the rows should be
updated with a RentalPriceID, based on the Year. Try
This: View the Data in the Table Go to
All Access Objects->Tables. Open a
Table: tblMovies. Try This
As Well: Sort the Records by Year Go to
Home ->Sort & Filter->Descending. What Do
You See? There are 3 RentalPriceIDs. 2012:
RentalPriceID 1. 2000-2011:
RentalPriceID 2. Before
2000: RentalPriceID 3.
|
|
| |
