Results 1 to 2 of 2
  1. #1
    falafelologist is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2015
    Posts
    1

    Is it possible to remove duplicates from a query based on values in a single column?

    I have a query that displays this


    Column1 Column 2 Column 3 Column 4
    TripTitleA TravelerA N/A N/A
    TripTItleB TravelerB N/A N/A
    TripTitleC TravelerC TravelerD TravelerE
    TripTitleC TravelerD TravelerC TravelerE
    TripTItleC TravelerE TravelerC TravelerD
    TripTitleD TravelerF N/A N/A

    I want to filter Column1 to have no duplicates so it looks like this

    Column1 Column 2 Column 3 Column 4
    TripTitleA TravelerA N/A N/A
    TripTItleB TravelerB N/A N/A
    TripTitleC TravelerC TravelerD TravelerE
    TripTitleD TravelerF N/A N/A


    Is this possible?

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    without knowing how your current query is constructed, difficult to advise.

    But assuming your data is normalised, using SELECT DISTINCT rather than just SELECT will do it. If it is not normalised then it probably can't be done without a huge amount of coding

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Remove close duplicates from query
    By prichardson in forum Queries
    Replies: 2
    Last Post: 02-15-2013, 12:40 PM
  2. Replies: 3
    Last Post: 01-30-2013, 07:44 AM
  3. Query to Sum Values and Remove Duplicates
    By noobaccessuser in forum Queries
    Replies: 1
    Last Post: 12-06-2012, 07:12 PM
  4. Remove duplicates based on date in another column
    By mlhend2002 in forum Programming
    Replies: 5
    Last Post: 12-26-2011, 01:47 PM
  5. Remove Duplicates Based on Criteria
    By suryaprasad in forum Access
    Replies: 0
    Last Post: 04-07-2011, 10:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums