|
8.
Try it: Review the Query Results The
Find duplicates for tblMoviesSQ
Query found two copies of one movie, "The Hunger Games." What
Else Did You Notice? This Query does not allow you to expand the
Rows to see both movies. If you could see both you would delete one. So, how do
you handle duplicates? If the
duplicate is a new Record that hasn't been used in any Receipts, you
can go to tblMovies and delete it. If the
duplicate was already used in a Receipt, you need to edit the
Receipt to use to correct movie before you delete the duplicate
movie. Still,
this little Query searched through the Movie Field and found two
that matched. How did it do that? Let's see
for ourselves.
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Find
Duplicates
Create->Queries->Query
Design-> Find Duplicates Query Wizard |
|
| |
