Solved Sum of field

[widemonk]

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

 

[bastanu]

Make it a totals query (click the sigma sign in the queries design view) and group by EventID and for the Expr field choose Sum in the totals row.

Cheers,

 

[Pat Hartman]

You need to remove the MemberID from the query. It is unique and so cannot be summarized.

 

[widemonk]

Awesome and thank you

 

[Pat Hartman]

You're welcome