Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008
    Posts
    3

    Question Unanswered: Duplicate entries in report

    Edit: I forgot to say...this is in Access 2003.

    I have a report based on a query. When I run the query, I don't get duplicate rows, but when I run the report, I do get duplicate rows. The weird part is that not all the data is duplicated. Only some of it.

    The query is based off of my Employee Table that has the fields (among others) of Employee ID (primary key), First Name and Last Name. The Training Table has Employee ID (linked one to many from the Employee Table), Training Name, Training Date and Training Hours.

    The Query uses all of the fields from the Training Table and the First Name and Last Name from the Employee Table. As I said, when I run the query, I get no duplicates records.

    I created the report from the reports wizard based on the query. It is grouped by Employee ID, and shows the First Name and Last Name of the employee, and then lists all trainings that employee has attended.

    Some employee records are fine, no duplicates. However, some employees are showing duplicate training records. However, not all of the training records for those employees are duplicated, just some of them. My initial thought is that I had entered duplicate records, but when I checked, there were not duplicates (it's a small database, so it was easy to check).

    Anyone have an idea why this is happening? If you could use small words it would help *laughs*. I'm an amateur.
    Last edited by Jodith; 05-22-08 at 14:27.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Can you post the database?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    and your certain the query used in the report is the same as the one you select?

    to get duplicates suggests to me that there is a problem in one or more of the joins. or possibly there is a rogue sub report.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by healdem
    and your certain the query used in the report is the same as the one you select?
    Quote Originally Posted by Jodith
    I created the report from the reports wizard based on the query. It is grouped by Employee ID
    They are not the same.
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •