Testing if a record exists in another table [Resolved]

[PilgrimPete]

Oh, I get it. I wasn't paying attention!

You'll be needing a subquery then...

strQuery = "SELECT Surname & Chr(44) & Chr(32) & Forenames " & _
          "AS FullName, IIF(IsNull(RegMem.MemID), ""N"", ""Y"") " & _
          "AS Present From Members LEFT JOIN (SELECT MemID FROM RegMem WHERE SDate = #" & Format(#7/4/2005#, "yyyy-mm-dd") & "#) RegMem " & _
          "ON Members.MemID = RegMem.MemID

I doubt if that is syntactically spot on, but you get the idea?