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

    Unanswered: duplicate results in my query

    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
    .

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    What results do you expect?

    Igor

  3. #3
    Join Date
    May 2002
    Posts
    395
    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


    TblA:
    Date Z
    12/1998 1773

    TblB:
    Date A O
    12/1998 8 6

    After joining the two tables by the date field I would like the result to display the values for that month.
    It should display as follow:
    Date A O Z
    12/1998 8 6 1773

    The TblA!Date was formatted as mm/dd/yyyy before I changed to mm/yyyy. Could that be the problem?

Posting Permissions

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