Results 1 to 3 of 3
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Query question - Selecting data (A2K SR1)

    TABLE 1 contains 10 records in Field 1. The records are 1,2,3,3,3,4,4,2,2,1
    TABLE 2 contains 5 records in Field 2. The records are 3,4,5,6,7

    Is it possible to create a query that selects all of the records in Table 2 that are not in Table 1? If not, is there an easy way to do this?
    Regards,

    Gary
    (It's been a while!)

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

    Re: Query question - Selecting data (A2K SR1)

    This is probably too simple: have you tried the Find Unmatched Wizard?

    Start to create a new query
    Select the Find Unmatched Wizard
    Select Table 2 in the first step
    Select Table 1 in the second step
    Indicate that you want to match on Field 2 vs Field 1
    Enter a name for the query (or leave as suggested)
    Finish.

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Query question - Selecting data (A2K SR1)

    ... Well I'll be darned.... this worked great. I never thought of using this feature.



    Thanks <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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