Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: query produced duplicate results

    I have two tables. tblA has two fields Date & Z, and tblB has three fields: Date, A & O.
    I inner joined(1st option in the Join Properties)the tables by the Date field but the query result shows listed three times

    Ex: Date A O Z
    12/1998 8 6 1773
    12/1998 8 6 1773
    12/1998 8 6 1773

    Thanks!

  2. #2
    Join Date
    Nov 2002
    Location
    The Netherlands
    Posts
    61
    Whats your primary key and is that dat unique??

  3. #3
    Join Date
    May 2002
    Posts
    395
    Thanks for your response.
    I think I just figured it out. I appended my query result onto the table so every time I ran the query the results in table incremented by the tt number of records in the query.

    I appreciate your help.
    Have a Great Day!

Posting Permissions

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