Results 1 to 2 of 2
  1. 01-29-2016, 09:09 AM #1
    mithrush
    mithrush is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2016
    Posts
    5

    SQL Query

    I have created an SQL query within Access 2007 but it has duplicated data. How can I remove the duplicated data please?
    Reply With Quote Reply With Quote
  2. 01-29-2016, 10:06 AM #2
    JoeM
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Do you know why the data is duplicated? It often indicates that you may have not done your join properly.
    If you did, and it just happens to be a one-to-many join, duplicate can be weeded out with a "SELECT DISTINCT..." statement or an Aggregate Query.
    Keep in mind though, that for in order for Access to consider it a duplicate, every field being returned must be a duplicate.

    If you post the SQL code of your query, and describe the relationship between your tables, we can probably help you clean it up.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums