Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Numbers?

Status
Not open for further replies.

llldnylll

Technical User
May 21, 2003
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?
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top