Testing if a record exists in another table [Resolved]

[olamm2k]

The missing 'AS' did throw me.

I've now got it as:

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

But why is the subquery needed?