By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
2 Replies


P: n/a
N. Graves <ng*****@yahoo.com> 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 <ng*****@yahoo.com> 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...

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.