UnMatch Query Multiple Records

[Ihussein]

Hello There,
I have two table tblRed & tblDistReg, please see attached db. I'm trying to write a query that return all the unmatch record in tblRed where the DateOfDist of the record in tblDistReg is null. in my attached db the qryUnmatch should return the records as an unmatched:
RCNb RCHolder VSN Remarks
SRCZM4000690 Charlis Rose 4
SRCZM4000690 Charlis Rose 5
SRCZM4000690 Charlis Rose 8

Regards

 

[arnelgp]

try query1 on attached.

 

[Ihussein]

All right I will give it a try.
Thanks for the prompt respond.