Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    25

    Unanswered: Query Not to include the results of another query

    I use Access 97.
    I tried to do it through SQL but getting syntex errors.

    I have 2 queries, and I'm trying to run another query to give me the results that are not in the second query.

    Query3 = Query1 - Query2

    Can someone help please?

    Thanks!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Have you tried the unmatched query wizard (presuming it is available in 97)?
    Paul

  3. #3
    Join Date
    Aug 2006
    Posts
    25
    I wasn't aware of unmatched query wizard. I'll look for it tomorrow at work if it's present in 97.

    Thanks a lot!
    comppal

Posting Permissions

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