Solved Sum of field (1 Viewer)

widemonk

Registered User.
Local time
Today, 19:54
Joined
Jun 16, 2005
Messages
48
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
 

Attachments

  • EventMemCountQuery.JPG
    EventMemCountQuery.JPG
    27.4 KB · Views: 247

bastanu

AWF VIP
Local time
Today, 12:54
Joined
Apr 13, 2010
Messages
1,401
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

Super Moderator
Staff member
Local time
Today, 15:54
Joined
Feb 19, 2002
Messages
42,973
You need to remove the MemberID from the query. It is unique and so cannot be summarized.
 

Users who are viewing this thread

Top Bottom