Duplicate Results In Access Query. 20132010 - Click the Create tab and then click Query Wizard. How To Find Duplicate Records In Access.
On the first page of the wizard select the table that has unmatched records and then click Next. When maintaining an Access. An Intro to Resolving Duplicate Results in SQL Queries by Meg McGinty.
In the list of tables select the table you want to use and click Next.
It is easier to use a query when you want to delete a lot of duplicate data. For example several employees listed in an Employees table may have the same last name. The process for starting the wizard varies depending on the version of Access you are using. In the new query dialog box tap to Find Duplicate Query Wizard option and then click Ok.