How to query for Parent Records with no matching Child Record?

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

2 tables...tblParent and tblChild...

ALL tblChild records have one related record in tblParent with DDD in
fldTitle
SOME tblChild records have _another_ related record in tblParent with CCC in
fldTitle
(So some tblParent records have ONE related tblChild record and some have
TWO.)

I want to find the tblParent records that have NO tblChild record with CCC
in fldTitle
(so these will be the tblParent records with only ONE related record... the
one with DDD in fldTitle)

I have both tables in the query grid with...
tblParent.fldName and tblChild.fldTitle
pulled down to the query grid

Criteria for tblParent.fldName is... Like "AAA*" (this selcts the record
set to consider)
Criteria for tblChild.fldTitle is ... ???? Nothing I try seems to work.

Thanks for any help on how to do this using the query grid...
 
Why not use the querywizard unrelated records and see if that can answer your
question. Just choose new in Query option and choose the specified option.

hth
 
Back
Top