Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2012
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Exclude Duplicates

    I have an access 2003 form with two unbound combo boxes. The first box pulls a list of customers from a table. The next box queries another table based on the customer ID from the first box. It lists the episode#'s that we have for the customer. The problem is there may be two records with episode 2 and three with episode 1. The Combo Box then lists: 1,1,1,2,2 instead of just 1,2. Is there anyway to exclude the duplicates? I know this is confusing, but maybe someone can make sense out of it and help.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Use the distinct keyword or a group by in the second combos query

  3. The Following User Says Thank You to patt For This Useful Post:

    sims.anderson2010 (2012-02-16)

  4. #3
    New Lounger
    Join Date
    Feb 2012
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks. That Worked

Posting Permissions

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