Show Records Where All Related Records Are False

C

Cliff

In a one-to-many table relationship, I need to show only records from the
primary table where a boolean field is False in ALL related records. It
seems simple but my knowledge of SQL is a little weak. Thanks for your help.

Mike
 
C

Cliff

I created a subquery where the boolean field criterium was False and
left-joined it to the main query having criteria for the boolean field in
the main query as True and the ID field of the subquery as Is Null (grouped
by ID field). I THINK I explained that right. ;-)

Thanks,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Records with null values aren't being returned 5
Counting the sum of related records for a primary record 4
Query Not Displaying All Main Table Records 1
Query showing all records from child table 5
Have both records from two queries/tables under one Query without related fields. 0
Access Dcount (multiple criteria) 3
Multiple Matching Records in Related Table 4
Find groups of records where a Boolean field is False 5

Top