Where condition in report text box

[kazaccess]

I have created a database for my sports team. I have a field called [Win/Loss] that shows a win or loss for the team. I realize I should have created two separate columns for this, but I am looking for a solution before having to do this. In my report, I have a grouping on [Win/Loss] to sort each game. What I would like to do is count the number of wins/losses for the year. Right now, it merely counts all of the records without specifying wins/losses. Is there a way to add a WHERE statement in the control source for my text box in order to count wins and then another for losses? Something like ... Where [Win/Loss] = 'Win' ?

[pbaldy]

Try

=Sum(IIf([Win/Loss] = 'Win', 1, 0))

[kazaccess]

Perfect. Thanks so much!

[pbaldy]

Happy to help!