(Msg. 1) Posted: Tue Jul 22, 2008 9:20 pm
Post subject: Ranking values in a report Archived from groups: microsoft>public>access>reports (more info?)
I have made a report that displays the count of times a person has won an
event. It also shows the name and winnings.
I have several thousand people being tracked and there are obviously
duplicate numbr of time various individuals have wou.
(Msg. 2) Posted: Wed Jul 23, 2008 3:00 am
Post subject: Re: Ranking values in a report [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
It also suggests that you turn this into an Append query and write the data
to a temporary table, which you use as the source for your report. (You will
find this necessary if you want to do any sorting or grouping of the data in
the report.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Wayne Zabel" <waynezabel DeleteThis @verizon.net> wrote in message
news:ewXqWJG7IHA.3692@TK2MSFTNGP05.phx.gbl...
>I have made a report that displays the count of times a person has won an
>event. It also shows the name and winnings.
> I have several thousand people being tracked and there are obviously
> duplicate numbr of time various individuals have wou.
>
> For example
>
> Count Player Winnings
> 84 ABC $5,000,000.00
> ---------------------------
> 79 DEF $4,000,000.00
> 79 GHI $4,500,000.00
> ---------------------------
> 70 JKL $3,000,000.00
>
> What I need is to rank the individuals and show ties.
>
> For example
> Count Player Winnings Rank
> 84 ABC $5,000,000.00 1
> ------------------------------
> 79 DEF $4,000,000.00 2
> 79 GHI $4,500,000.00 2
> -------------------------------
> 70 JKL $3,000,000.00 3
>
> All help will be appreciated
>
(Msg. 3) Posted: Wed Jul 23, 2008 6:36 am
Post subject: Re: Ranking values in a report [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks for the quick response. You have solved my problem.
Wayne
"Allen Browne" <AllenBrowne.DeleteThis@SeeSig.Invalid> wrote in message
news:OB7nI8G7IHA.3816@TK2MSFTNGP03.phx.gbl...
> See:
> Ranking or numbering records
> at:
> http://allenbrowne.com/ranking.html > The article explains how to use a subquery to rank in a query.
>
> It also suggests that you turn this into an Append query and write the
> data to a temporary table, which you use as the source for your report.
> (You will find this necessary if you want to do any sorting or grouping of
> the data in the report.)
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org.
>
> "Wayne Zabel" <waynezabel.DeleteThis@verizon.net> wrote in message
> news:ewXqWJG7IHA.3692@TK2MSFTNGP05.phx.gbl...
>>I have made a report that displays the count of times a person has won an
>>event. It also shows the name and winnings.
>> I have several thousand people being tracked and there are obviously
>> duplicate numbr of time various individuals have wou.
>>
>> For example
>>
>> Count Player Winnings
>> 84 ABC $5,000,000.00
>> ---------------------------
>> 79 DEF $4,000,000.00
>> 79 GHI $4,500,000.00
>> ---------------------------
>> 70 JKL $3,000,000.00
>>
>> What I need is to rank the individuals and show ties.
>>
>> For example
>> Count Player Winnings Rank
>> 84 ABC $5,000,000.00 1
>> ------------------------------
>> 79 DEF $4,000,000.00 2
>> 79 GHI $4,500,000.00 2
>> -------------------------------
>> 70 JKL $3,000,000.00 3
>>
>> All help will be appreciated
>>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other