This write-up was written by MysticGeek, a technology blog owner at the How-To Geek Blogs.
Encountering replicate data in an Access Database can be quite aggravating throughout the stressful workday, so I decided to write up a technique to help determine the duplicate records so you can manually handle them.
There are lots of causes for replicate information: for instance if you have numerous customers getting in information all at once by means of linked tables, or you may inherit a table with duplicate data already got in.
First open the MDB (Microsoft Database) containing the table you wish to check for matches. Click on the Queries tab as well as New.
This will certainly open up the New Query dialog box. Highlight Find Duplicates Query Wizard after that click OK.
Now highlight the table you intend to check for replicate data. You can additionally pick Queries or both Tables as well as Queries. I have actually never ever seen an usage for looking Queries … but perhaps it would be available in convenient for one more’s scenario. As soon as you’ve highlighted the proper table click Next.
Below we will certainly select the field or fields within the table we want to look for duplicate data. Attempt to prevent generalized fields.
Name the Query as well as struck Finish. The Query will run today and turn up the results. Additionally the Query is saved in the Queries section of Access.
Depending upon the chosen tables and also areas your outcomes will look something comparable to the shots below which show I have nothing copied in the first shot and also the outcomes of duplicates in the other.