Conditional "Is Null" Query Criteria

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?
.

Relevant Pages

  • Re: Placing Query By Design Grid On Form
    ... import some forms and tables into your application then create some master ... queries. ... The DH QBF is a complete query by form applet that can be easily integrated ...
    (microsoft.public.access.formscoding)
  • RE: Count Null Values Per Field
    ... You could do a total query something like below. ... The first field will show the ... I am building a master attribute table for over 6,000 location, and am ... queries, each one counting the number of null values, then do one query ...
    (microsoft.public.access.queries)
  • Re: Please help! (Reports and Queries)
    ... My solution depends on naming your master datasource queries with names like ... Add your datasource query names into this table. ... I need to be able to action a number of queries (& also reports) on my ...
    (microsoft.public.access.queries)
  • Re: Query miscalculations, why?
    ... there are a number of different queries that independently ... >total up the different sections of the Daily Report. ... >master query called QryDateParameterReport (this is because I believe reports ... >this single query, that is why all the queries feed into it). ...
    (microsoft.public.access.queries)
  • Re: Customized report based on user input.
    ... The DH QBF is a complete query by form applet that can be easily integrated ... The developer creates one or more master queries that join tables, ... Word merge, Excel, HTML, CSV, Merge to Report, or a graph. ...
    (microsoft.public.access.reports)
Loading