Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    8

    Unanswered: Displaying Only Unique Values In A Query

    Ok, I have 2 tables. One lists 10 names. The other has only 4 of the 10 names. I want to create a query that will display only the 6 remaining names (10-4=6). I tried listing both tables together, and displaying unique values, and it eliminated the 4 duplicates, but still listed the 10 names. I do not want to delete the records, I just want to display the only ones that arent listed twice. This seems simple, but yet I am having trouble with it. If someone could help me I would appreciate it. Thanks.

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    Create a query to show the duplicates first. There is a query wizard to help with that.

    In the duplicate query make sure you have the pk for the table containing the 10 names.

    Make a second query with a criteria that the pK does not equal the pK in the duplicate query.

    HTH

  3. #3
    Join Date
    Sep 2002
    Posts
    8

    Re: Displaying Only Unique Values In A Query

    In Access 2K, there is a wizard called 'find unmatched query wizard". Is this what you are looking for?

    _________________________________________
    Originally posted by bcmark21
    Ok, I have 2 tables. One lists 10 names. The other has only 4 of the 10 names. I want to create a query that will display only the 6 remaining names (10-4=6). I tried listing both tables together, and displaying unique values, and it eliminated the 4 duplicates, but still listed the 10 names. I do not want to delete the records, I just want to display the only ones that arent listed twice. This seems simple, but yet I am having trouble with it. If someone could help me I would appreciate it. Thanks.

Posting Permissions

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