Count number of records

[gheyman]

I have a subform on a form where the user uses the built in column filters to refine the Dara. Each record has a field where the data is Won, Loss of expired. There is also a value field. Above the subform I would like to show the number of Wins, Losses... and the total value for each category each time they filter something.

Can you help me achieve this?

 

[alansidman]

Create a query and use that as the record source for the Wins/Losses.