Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2003
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplicate Rows in Application (Access XP)

    I have an Access front end for a SQL database with one form showing duplicate rows, this is also the case in the table view in access however if you view the same table in SQL Query Analyser the data is shown correctly. This is the query:
    SELECT Events.EventDescription
    , Updates.AssetNo
    , Updates.UpdateDate
    , Updates.TRFrom
    , Updates.TRTo
    , Updates.TRReason
    , Updates.BMApproval
    , Updates.ACApproval
    , Updates.BMApprovalDate
    , Updates.ACApprovalDate
    , Updates.Description
    , Updates.Cost
    , Updates.EventID
    , Updates.UpdateID
    FROM Updates
    LEFT JOIN Events ON Updates.EventID = Events.EventID
    where assetno = '20150'

    Does anyone have any suggestions as to why this is happening cos I'm at my wits end! <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Duplicate Rows in Application (Access XP)

    Are you sure that if you view the Updates table for that specific AssetNo you get multiple records?
    Your query contains a join to the Events table, and with that structure you will see a copy of the record for every record in the Events table that matches that EventID.
    Finally, is the field AssetNo the primary key for the table?
    Wendell

  3. #3
    Star Lounger
    Join Date
    Jun 2003
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate Rows in Application (Access XP)

    The primary key for the table is the UpdateID and currently there is only entry in the events table so there should still be only one record. This is linked to another post regarding refreshing data.

Posting Permissions

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