Testing if a record exists in another table [Resolved]

[PilgrimPete]

Because you don't want to limit the whole result set, just the subset of members present on that date.

The original query I posted had the following logic:
Return rows for all members, joining all records in RegMem, marking those not present with an 'N', BUT that have a row in RegMem with an SDate of xyz. This is contradictory rubbish.
The revised query has this logic:
Return rows for all members, joining ONLY those rows in RegMem with an SDate of xyz, marking those not present with an 'N'.

This is surprisingly hard to explain!
Hope I got close though

[olamm2k]

It's an odd concept to get your head around, but I think the first query would be the same as doing:

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

Thanks for your help.