469,071 Members | 2,003 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,071 developers. It's quick & easy.

Removing duplicate records in multiple fields

I have a table in MS Access 2010 the fields are name, drug 1, drug 2, enzyme marker. The table looks like this:
Name-Field 1-Field 2-Enzyme marker
Mary Tylenol Aspirin enzA
Mary Aspirin Tylenol enzA

I would like to remove one of the records and not be left with duplicate records. Thanks, Carl
Mar 24 '13 #1
1 1660
12,516 Expert Mod 8TB
You should normalize your data so that future querying will be easier. Meaning you should only have one drug column and two rows in your example.

You can use a union query to normalize and deduplicate your data. Insert the result of that into a new table.
Mar 25 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Ben Willcox | last post: by
1 post views Thread by sumit | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.