Conditional "Is Null" Query Criteria
- From: "veaux@xxxxxxx" <veaux@xxxxxxx>
- Date: Thu, 5 Jun 2008 09:23:56 -0700 (PDT)
Question deals with linking tables in queries. I'm not a code writer
so use the GUI for all my queries.
Table 1 - Master
Table 2 - Sub1
Table 3 - Sub 2
All 3 tables have the same key field.
I'm trying to find all the records that are in "Master", that are not
in Sub1 or Sub2. Just doing that I have but doing show me all in
"Master" and using Join Property 2 and Is Null for both Sub1 and Sub2.
What I really want to do though is show me all records in "Master"
that are not in Sub1 or Sub2, but only when Sub1.Fieldname = "Jones".
If I put "Jones" in the criteria section of query, I get nothing. I
know I could create another query for Sub1.Fieldname = "Jones" and do
the above off of that, but I'd rather not create the add'l queries.
I haven't understood how you can do the "Is not in table X, when only
looking at Table X records where Fieldname = "Jones".
Hope the above makes sense?
.
- Follow-Ups:
- Re: Conditional "Is Null" Query Criteria
- From: Rich P
- Re: Conditional "Is Null" Query Criteria
- Prev by Date: Re: Controls no longer showing
- Next by Date: SQL help
- Previous by thread: getting duplicates with subforms and different tables
- Next by thread: Re: Conditional "Is Null" Query Criteria
- Index(es):
Relevant Pages
|
