Dec 19, 2006 #1 llldnylll Technical User Joined May 21, 2003 Messages 89 In my table, one field is for points. Is there a way that I can create a query that will add up all the points? How about filtering them by users?
In my table, one field is for points. Is there a way that I can create a query that will add up all the points? How about filtering them by users?
Dec 19, 2006 #2 IGPCS Programmer Joined Oct 26, 2006 Messages 431 Location US if i get your needs in your short words so do the following create a query from based on you table and in the query add 2 fields UserField Point right click on the query design and click on sum and for user choose group by and for the points choose sum I will try my best to help others so will others do!!!!! IGPCS Brooklyn, NY Upvote 0 Downvote
if i get your needs in your short words so do the following create a query from based on you table and in the query add 2 fields UserField Point right click on the query design and click on sum and for user choose group by and for the points choose sum I will try my best to help others so will others do!!!!! IGPCS Brooklyn, NY