Counting members & selecting names [Resolved]

[olamm2k]

Hi,

I'm using the same tables as in my previous post ( http://www.vbforums.com/showthread.php?t=328403 ), but I now need to count the number of members present on a date.

The query I have so far is:
SELECT Members.MemID, COUNT(RegMem.MemID) AS NumPresent FROM Members LEFT JOIN RegMem ON Members.MemID = RegMem.MemID GROUP BY Members.MemID;

This returns a list of MemIDs against the number of sessions that they have been to, but I also need the names of the members, which are contained in the Members table and are matched uniquely to their MemID. I could do this in a second query, moving through each MemID in the first query to obtain a name, but I think it's possible in one query. I don't need the MemID returned and I can't just GROUP BY Surname because some members are siblings.

Any ideas?