Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    29

    Unanswered: Repeated Names in Access

    Hey this might be a rather simple question but i cant find the answer on the access tutorials n such....

    My problem is:

    I have a column of the names of people who own property, some own more than one... what i wanna do is delete all the repeated names and just leave one?

    thanks for the help

  2. #2
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Select (distinct)

    Create a new (blank) table with a column or columns for the names you want to hold and write a SELECT DISTINCT(Name) INTO query. There should be plent of help for the SELECT INTO query. Then use the new table (rename it if necessary).

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Under the query Tab there is a wizared will help you getting the repeated Items in any table

  4. #4
    Join Date
    Oct 2004
    Posts
    29
    thank you both

Posting Permissions

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