#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    0

    Report Duplicating in Access - Desperate need of help


    Help!! I know this is going to be so simple to someone but i need help. I am self taught on access and my database has been perfect. Recently i have had to add another field into a table and it is now throwing out my reports. Basically before, i had one account number per customer but now that is not the primary key as i now have one account number with several branches so the only thing that can be the primary key now is the customer name. I have changed the primary key, but now all of my reports are duplicating the data. I can get around this by removing duplicates in excel, but i know there must be a simple stupid thing i have done that can be rectified. I just cant work out what!!
  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    59
    Double Posted??

    Using the customer name as a primary key is not a good idea, although it may be a rare occurance, you may have two customers with the same name. Instead of using the account number or the customer name as the primary key, consider using a new field with a datatype of autonumber as your primary key.
    Changing the primary key on a database is not a simple matter. it's most likely that most of your queiries and reports either use the old primary key as part of a relationship or as some type of filter to limit your results. Basically when you change a primary key in some cases you almost endup reworking the entire database. Which is why selecting the correct primary key to begin with is so important. (When in doubt, use an autonumber field.)
    Without seeing your specific applicaiton there is no way to know how wide spread the change has effected your application. There's also no way to tell you how to fix it. If you want to post it to a file shareing site so that we can take a look, then someone may be able to help you. (remove all confidential information and compact and repair it.)
  4. #3
  5. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    0
    Ok, I understand what you are saying. My problem is that for example I have a report that is not duplicating information but if i recreate that report in exactly the same way, it duplicates things. Basically i have 4 tables, one is customer details, one is invoices etc. Those are the two that i use. I am asking the design wizard to give me 2 pieces of information from the customer details and the rest from the invoice. For some reason it is duplicating the information, so it will give me the details for some invoices 20 times? I cannot for the life of me work out why? I have now done what you suggested and used auto number in my customer detail table to differentiate and use as a primary key but in my invoice table, there is always only one invoice per number so the invoice number is the primary key.
  6. #4
  7. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    0
    Also, please can you tell me a file sharing site so that i can post it?
  8. #5
  9. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    59
    box.com

Similar Threads

  1. Desperate RIM considering Windows switch, says report
    By RSS_News_User in forum Technology News
    Replies: 0
    Last Post: June 29th, 2012, 10:00 AM
  2. Report is duplicating data
    By Greta06 in forum Microsoft Access Help
    Replies: 6
    Last Post: May 22nd, 2012, 12:09 PM
  3. MS Access Duplicating databases when saving.
    By bstone2 in forum Microsoft Access Help
    Replies: 4
    Last Post: August 1st, 2008, 03:16 PM
  4. Re: Access Mailmerge...Desperate: msg for Colm
    By stevie g in forum Microsoft Access Help
    Replies: 3
    Last Post: March 14th, 2005, 02:57 AM
  5. Re Access mail merge ...desperate!
    By stevie g in forum Microsoft Access Help
    Replies: 19
    Last Post: March 8th, 2005, 01:42 PM

IMN logo majestic logo threadwatch logo seochat tools logo