425,830 Members | 682 Online
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

# Help: Counting Records for a report

 P: n/a I have a table with records of games played with a field for players name and another fields is a "WinorLose". One player may play several games to complete a match. I want my report to tell me how many Wins or Loses and Individual has in a match.. I'm not having a problem getting the reports and the grouping it by person but I'm having a problem with the logic of counting and display number of Wins and number of Loses. Is there some way to say "if WinorLose="Win" then WinCount = WinCount+1 else LoseCount = LoseCount+1" then display these numbers in my report? Thanks Norris x-- 100 Proof News - http://www.100ProofNews.com x-- 3,500+ Binary NewsGroups, and over 90,000 other groups x-- Access to over 800 Gigs/Day - \$8.95/Month x-- UNLIMITED DOWNLOAD Nov 12 '05 #1
2 Replies

 P: n/a N. Graves wrote in message news:<84********************************@4ax.com>. .. I have a table with records of games played with a field for players name and another fields is a "WinorLose". One player may play several games to complete a match. I want my report to tell me how many Wins or Loses and Individual has in a match.. I'm not having a problem getting the reports and the grouping it by person but I'm having a problem with the logic of counting and display number of Wins and number of Loses. Is there some way to say "if WinorLose="Win" then WinCount = WinCount+1 else LoseCount = LoseCount+1" then display these numbers in my report? Thanks Norris do something like in your query and then do a running sum? Win = iif([GameResult]="Win",1,0) Losses = iif([GameResult="Loss",1,0) then you could do a running sum over the group... Nov 12 '05 #2

 P: n/a On 30 Oct 2003 21:15:33 -0800, pi********@hotmail.com (Pieter Linden) wrote: N. Graves wrote in message news:<84********************************@4ax.com>. .. I have a table with records of games played with a field for players name and another fields is a "WinorLose". One player may play several games to complete a match. I want my report to tell me how many Wins or Loses and Individual has in a match.. I'm not having a problem getting the reports and the grouping it by person but I'm having a problem with the logic of counting and display number of Wins and number of Loses. Is there some way to say "if WinorLose="Win" then WinCount = WinCount+1 else LoseCount = LoseCount+1" then display these numbers in my report? Thanks Norrisdo something like in your query and then do a running sum?Win = iif([GameResult]="Win",1,0)Losses = iif([GameResult="Loss",1,0)then you could do a running sum over the group... Pieter Linden, Thanks so much for your help. I took this information applied it and it gave me the results I was looking for. What a great Group and News Readers!!! Thank You! Norris x-- 100 Proof News - http://www.100ProofNews.com x-- 3,500+ Binary NewsGroups, and over 90,000 other groups x-- Access to over 800 Gigs/Day - \$8.95/Month x-- UNLIMITED DOWNLOAD Nov 12 '05 #3

### This discussion thread is closed

Replies have been disabled for this discussion.