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

Copy to a New Table Try it: Run the Make Table Query Select the ArchiveMovieUQ query. Save as: ArchiveMovieMT     Select Design ->Make Table. Name the table: tblArchivedMovies   Go to Design ->Results -> Run   Review the Results. There will be a new tblArchivedMovies table that has movies that were released before 2000. Query Tools -> Design ->Results -> Run