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

Unmatched Query Results Find Unmatched Record Wizard Select the first table: tblArchivedMovies Select the second table: tblMovieTitles   Match the fields: ID Select all of the fields for this query. Save the query; UnmatchedMoviesSQ.   Try it: Run the Query There should be NO UNMATCHED RECORDS in this example!   That's good. The purpose of this query was to determine if all of the movies in the new archived movie table match the ones in tblMovieTItles.   What is this query looking for? How does it work? Create ->Query Wizard  -> Find Unmatched Query Wizard