Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Make Table Problem (2003)

    I have a make table query, which brings data together from several tables. Some of the records in the 'made table' are duplicated, but in the original table they come from are not. How can I find out what's causing it.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Make Table Problem (2003)

    If you have joins in the Make Table query, you may have duplicate records in one or more of the joined tables.
    If the duplicated records are exactly the same, you may consider changing the query to SELECT DISTINCT. This will most times take care of the duplicated records.
    Richard

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Make Table Problem (2003)

    Not all the records are duplicated, but the records that are, are exactly the same. I need to have this a 'Make table' query, to update the data.

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

    Re: Make Table Problem (2003)

    Have you actually tried Richard's suggestion? The equivalent in design view is:
    - Click in an empty part of the upper part of the query design window.
    - Activate the Properties window (its caption should be Query Properties)
    - Set Unique Values to Yes.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Make Table Problem (2003)

    Rob

    Sometimes when making a Make table query it is best to create it as a normal Select query first. This will allow you to preview, and check the data prior to making it into an Action query. In the past when I have done major data extracts is to run a duplicate query on that Select query to check for any anomalies. When I am happy the data is correct I convert it into a Make Table query or Append query as required. If you are happy with SQL ( I apologise if you know this already, I don't know your ability) Go into the SQL part and change it to SELECT DISTINCT this should just give unique records.

    Good luck
    Jerry

Posting Permissions

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