Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Report Duplicating in Access - Desperate need of help

Results 1 to 5 of 5
Share This Thread →
  1. #1
    LisaC is offline Registered User
    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
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    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.)

  3. #3
    LisaC is offline Registered User
    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.

  4. #4
    LisaC is offline Registered User
    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?

  5. #5
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    box.com

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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, 09:00 AM
  2. Report is duplicating data
    By Greta06 in forum Microsoft Access Help
    Replies: 6
    Last Post: May 22nd, 2012, 11:09 AM
  3. MS Access Duplicating databases when saving.
    By bstone2 in forum Microsoft Access Help
    Replies: 4
    Last Post: August 1st, 2008, 02: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, 01:57 AM
  5. Re Access mail merge ...desperate!
    By stevie g in forum Microsoft Access Help
    Replies: 19
    Last Post: March 8th, 2005, 12:42 PM

ASP Free Advertisers and Affiliates