|
This
discussion began by importing
the new movies into the Movie Table and checking for duplicates. We also created several
Action Queries to simplify the task of
archiving the old movies. The steps included adding new Fields
to the Movie Table: Archived, Status and and Memo. We also added
those Fields to the Movies Form. The Action
Queries included: An Update
Query, ArchiveMovieUQ to UPDATE the Archive
Field to Yes for the old movies. A Make
Table Query, ArchiveMovieMT, to copy the Archived Records
into a new Table: tblArchiveMovies. Two
new Action Queries to Test the Data: Find duplicates for
tblMoviesSQ
ArchiveMovieMT Now that
was a very good lesson. You done good! Go get the
cookies!
|
|
| |
