How to reduce duplication in Access 2003

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

cathing59

Thread Starter
Joined
Nov 30, 2011
Messages
6
Hi. I have imported tables into Access that contain alot of information, from products to personnel, customers and inventory. If I try to query an individual product, for instance, my results indicate all of the times that the product was entered in each of the tables. Is there a unique ID I can use to reduce the duplication and only get each occurrence linked to one time? Does that make sense? Thank you.
 
Joined
Jul 29, 2001
Messages
21,334
What did you import the data from? If there are no primary keys or foreign keys for related tables you are going to have to figure out how to associate them. For example if you have a db based on cars you would have a make table for ford, chevy, etc. You would also have a model table and have entries like Escort for Ford and a relationship between the make and model table
Make Table:
Make_PK
Make_Name

Model Table:
Model_PK
Make_PK Foreign Key from Make table
Model_Name
 

OBP

Joined
Mar 8, 2005
Messages
19,895
As Rockn says the data should really be "Normalised" so that the data relates correctly.
If you just want a quick list without duplication you can use the "Totals" and "Group By" function, however it only really works well with a single field, the more fields you add the more duplication is likely.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top