Combining three queries [Resolved]

[olamm2k]

Ref:
1. http://www.vbforums.com/showthread.php?t=328403 for table descriptions
2. http://www.vbforums.com/showthread.php?t=328505 for some of the query stuff I was doing last night
3. http://www.vbforums.com/showthread.php?t=240883 for details of someone who wanted something similar

I'm trying to combine three queries to produce a report for each member, passing the parameter intMemID into a query to return:
1. The member's name
2. The number of sessions they have been to
3. The total number of sessions that have occurred

Using the following, I can get all of the information:
(SELECT Forenames & Chr(32) & Surname FROM Members WHERE MemID = intMemID)
UNION ALL
(SELECT Count(MemID) AS SessionsAttended FROM RegMem WHERE MemID = intMemID)
UNION ALL
(SELECT COUNT (SDate) FROM (SELECT SDate FROM RegMem GROUP BY SDate))

But my question is, how do I modify the query so that instead of having the data displayed in 3 separate rows, it is displayed as 3 fields in one row?

I've been messing around with INNER JOIN for about an hour now to get what I want, and it's just not coming.