Administrator: Rave Reviews Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 More

Select the Oldies Say you decided to archive all of the old movies that came out before the turn of the century.   Here is what you need to do: 1. Select the archived movies. 2. Copy the selected movies to a new table. This will be a Make Table query. 3. Confirm that the new table does not have any duplicates   Try it: Select the Archived Movies Go to Create->Query Show Table: tblMovieTItles   Add all fields except the Memo. Enter a Criteria for Year: <2000   Run the Query This query should SELECT 206 movies. Create ->Query