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

Review the Query As you went through the Find Unmatched Query Wizard, you were asked how these two tables would be related. In this example, the tables are joined together on ID, the unique integer for each movie in both tables.   Try it again: Edit one of the movie titles in the tblMovieTItles.   Run the UnmatchedMoviesSQ query. Did your query find the mismatched titles? Why not?   Review the Joins This query is looking for any ID in tblArchivedMovies that does not have a matching ID: tblMovieTitle![ID] is Null.   The query is NOT linked by the Movie field, so it cannot compare whether the titles match or not. Query Tools -> Design