I will apologise in advance - perhaps this is the wrong time of night, wrong frame of mind... my head is just mush - I should know this!!
How do I get this query to return the number of people that attended each event?
The Expr = number of people (eg MemID #7 had a 'plus 2' of non-registered members so their attendance number is 3, the member + 2 friends).
Ultimately Id like this query to return just 3 records (MemID will be unchecked/hidden to obtain unique values etc)
EventID1 = 9
EventID2 = 5
EventID3 = 8
How do I get this query to return the number of people that attended each event?
The Expr = number of people (eg MemID #7 had a 'plus 2' of non-registered members so their attendance number is 3, the member + 2 friends).
Ultimately Id like this query to return just 3 records (MemID will be unchecked/hidden to obtain unique values etc)
EventID1 = 9
EventID2 = 5
EventID3 = 8