1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

How to reduce duplication in Access 2003

Discussion in 'Business Applications' started by cathing59, Dec 1, 2011.

Thread Status:
Not open for further replies.
  1. cathing59

    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.
     
  2. Rockn

    Rockn

    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
     
  3. OBP

    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.
     
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 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1029267

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice