Comma Training Page 289

Find Duplicates Query Design

The Query Design is fascinating. Once you see how it works, one can only marvel at the simplicity.

9. Try it: Review the Query in Design View

The Find duplicates for tblMoviesSQ Query is open.

Go to Home->Views->View->Design View.

What Do You See? This Query has one Table: tblMovies. There are only three Fields in the QBE Grid. The Totals Row is available. Queries read from left to right. So this Query is asking three questions.

Movie Field: Movie asks "Which movie? Is this the first time we've seen this movie in the list?" This Field looks in tblMovies for the First time a movie appears.

NumberofDups: Movie asks "Is there more than one copy of this movie?" This Field looks in tblMovies and Counts the Records. The Criteria is (Greater than) >1.

Movie asks "Are we the same? Ok, let's Group!" This Field Groups the movies that match.

Show or Hide: The last Column in the Query does not have a check mark for Show. So, this Field will not be seen in the Query results. It is hidden. Please Close the Query.