| | Microsoft Office Assistance: Find, eliminate, or hide duplicate records in Access (Site not responding. Last check: 2007-10-20) |
 | | I want to view only the duplicate records (those found in both tables) and hide records that are unique to either of two tables. |
 | | To be specific, if there are two duplicate employee records with the same hire date, the query will not delete either of the records, even though the underlying totals query returns only one of the two duplicate records. |
 | | Another way to review duplicate data in two similar tables is to focus just on the duplicate records — view only records that have a match in the other table, and hide the unique records that are in either table. |
| office.microsoft.com /en-us/assistance/HA010345581033.aspx (10134 words) |