Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reference another query (2003)

    I have a query of client numbers that I would like to exclude from another query. The field is Client Number. I would like to say in the criteria for the client number field in my query - Not in (name of query.client number). Is this possible.

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reference another query (2003)

    Link on Client ID with an outer (greater than) join from clients you want to see the to excluded clients. Place the excluded clients field in you query and set you criteria to Is Null
    Attached Images Attached Images

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reference another query (2003)

    Linda,
    Please see updated post - in case you are going off my directions from the "Lounge Admin" email. Sorry - I was thinking backwards.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reference another query (2003)

    Thank you so much - that worked perfectly......

Posting Permissions

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