Calculations within a table

[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 ....

 

[Graham Mandeno]

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.

 

[Guest]

-----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 ....

Thanks for your help Graham!