Calculations within a table

  • Thread starter Thread starter MAB
  • Start date Start date
M

MAB

Hi ... new to Access.

I have a table with statistics from soccer players over
several seasons. Is it possible to total fields, where
the players name is the same, into a unique row?

Example:

Player Season Gls Pts
Smith, Joe 1 2 3
Smith, Mike 1 3 5
Smith, Mike 2 4 6
Smith, Paul 1 1 1


Thanks in advance for any help ....
 
To do this you use a "group by" query.

Create a query based on your table and click on the totals button (Greek
"sigma") on the toolbar. Double-click on Player, Gls, and Pts to add them
to your query grid. Change the "Group by" under Gls and Pts to "Sum" and
run the query.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.
 
-----Original Message-----
To do this you use a "group by" query.

Create a query based on your table and click on the totals button (Greek
"sigma") on the toolbar. Double-click on Player, Gls, and Pts to add them
to your query grid. Change the "Group by" under Gls and Pts to "Sum" and
run the query.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

Hi ... new to Access.

I have a table with statistics from soccer players over
several seasons. Is it possible to total fields, where
the players name is the same, into a unique row?

Example:

Player Season Gls Pts
Smith, Joe 1 2 3
Smith, Mike 1 3 5
Smith, Mike 2 4 6
Smith, Paul 1 1 1


Thanks in advance for any help ....
Click to expand...
Click to expand...

Thanks for your help Graham!
 
Back
Top