Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2006
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Records Deletion (2003)

    Hi folks. I have a table in access with multiple records. I want to keep one of each record and dump the rest - how do I do this without having to do it manually?

    Thanks.

    Ina

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Records Deletion (2003)

    Are the 'multiples' completely identical in all fields, or is there a unique identifier such as an AutoNumber field?

  3. #3
    Star Lounger
    Join Date
    Jul 2006
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Records Deletion (2003)

    Hi. They are completely identical - no autonumber or primary key

    Ina

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Records Deletion (2003)

    You could do the following:
    1) Copy, then paste the table in the database window and select the option to paste the structure only.
    2) Create a query based on the original table (containing duplicates).
    3) Add all fields (or *) to the query grid.
    4) Activate the Properties window.
    5) Set the Unique Records property to Yes.
    6) Switch to datasheet view to check that the query doesn't return duplicates, then switch back to design view.
    7) Select Query | Append Query.
    8) Specify the new table you created in step 1) as target.
    9) Access should automatically fill in the 'Append to' line.
    10) Select Query | Run... or click the Run button on the tool bar.
    11) Check that the new table has been populated with unique records.
    12) You can now discard the query and the original table.

  5. #5
    Star Lounger
    Join Date
    Jul 2006
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Records Deletion (2003)

    Och, I should have thought of Unique records. Thanks Hans.

    Ina

Posting Permissions

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