Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    duplicate records (XP)

    Please look at the sample attached. My problem is I've imported the Excel data into a new Access database. I need to get rid of the duplicate occurances of the site name without getting rid of any of the records for each site. Clear as mud? Nah - I know you know what I mean!

    Thanks again

    Linda
    Attached Files Attached Files

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: duplicate records (XP)

    In Access, select Tools...Analyze...Table... and see if this describes what you want to do with (to) your table. If so, this Wizard will step you through the process.

Posting Permissions

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