Sum when field changes

[wasvsdal]

Hi,

I have a database where I need to sum one field, when a certain field changes. Please see example below:

A B
1 Redskins
2 Redskins
3 Cowboys

I want to be able to sum at the point when Redskins changes to Cowboys, and show that A=3. Then likewise for Cowboys, ..., etc.

How can I do this in MS Access 2003? Thank you!

 

[gemma-the-husky]

select the items in a query, change it to a totals query

look at the totalling options - max/sum/count etc - you sohuld find what you want

 

[wasvsdal]

My goodness...I feel so dumb right now. I shouldve thought of that myself. But wow thank you so much, that was very helpful.

 

[frankietp]

that's easy to code with VBA too