Joined: 15 Oct 2009
Location: United States
Online Status: Offline
Posts: 3
Topic: Tallying actions for a single user Posted: 27 Oct 2009 at 3:58pm
Hello,
I am trying to count (or possibly sum) the number of times that a specific user (PersonID) has participated in different events (EventID).
There are literally thousands of events, and even more users, but I want to get totals for each user. For example:
User1 35 events User2 31 events User3 18 events
etc.
I'm trying to do this with a running total field, but I keep getting numbers that are very inaccurate (I think that they're summing the total number of users).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum