Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    keeping table values unique (off 97)

    hello all i am sure this is a simple question. i have a table that gets its data impported daily. as a result some of the data is often repeated. i have a query that finds all unique values within that table. i would like to take the results of my query and use them to create a cleaner tbale. i would run the query. delete the old table. then copy the query data to a table that had the same name as the one i just deleted. all i want to do is cleanse to keep the file size down. is this possible?

    Ed

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

    Re: keeping table values unique (off 97)

    Try turning your query that selects the unique records into a "Make Table" query. Unfortunately, Access doesn't let you use the same table as both the source (the queried table) and destination (the "made" table), so you may have to delete your old table and rename your new table -- or you could use a second Make Table query to replace the old table with a copy of the new one.

    Hope this helps.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: keeping table values unique (off 97)

    You could introduce another field (Yes/No) in the table, and set this field to Yes if the field is unique via an update query.
    Using a delete query, delete those entries where the field is not Yes.

    That would not work, Tom's idea is better.

    HTH
    Pat

Posting Permissions

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