Getting totals for category

I

itsrightthere

I want to know how much the boys scored and how much the girls scored
in soccer.

I have a drop down menu which is a guery that gives me the selections
boys and girls. Now I have a textbox next to the menu where i want to
display the scores for whatever the selection is.

Gender: ______ Score: _______
 
J

John Vinson

I want to know how much the boys scored and how much the girls scored
in soccer.

I have a drop down menu which is a guery that gives me the selections
boys and girls. Now I have a textbox next to the menu where i want to
display the scores for whatever the selection is.

Gender: ______ Score: _______
Click to expand...

Create a Totals query. Create a query based on your table; click the
Greek Sigma icon (like a sideways M). Select Group By for the Gender
field, and Sum for the score field.

John W. Vinson[MVP]
 
Top