By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,481 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,481 IT Pros & Developers. It's quick & easy.

Continous Form Records Ranking

P: n/a
Jim
I have a form that is using a query for the control source. The query
put the data in order of TOP 20. I've added an extra textbox in the
form and want to be able to automatically rank the records and award
points for the top averages. what would be the best approach to
assigning values according to the ranking? Thanks in advance.

May 17 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
See:
How to Rank Records Within a Query
at:
http://support.microsoft.com/kb/208946/en-us

--
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.

"Jim" <jm*****@sbcglobal.net> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...
I have a form that is using a query for the control source. The query
put the data in order of TOP 20. I've added an extra textbox in the
form and want to be able to automatically rank the records and award
points for the top averages. what would be the best approach to
assigning values according to the ranking? Thanks in advance.

May 17 '06 #2

P: n/a
Jim
Thank you for the Reply. I read through this article and tried it on my
database, no luck. It will add the records up and place that number in
the query column, but they are all the same number. Whatever the count
added up to. I've tried changing the signs around and only get addition
and subtraction from the record count. Here is how it laid out.

1. I have a table named "Results". I've used a query to add all the
totals and append them to the right place.

2. My next step is to sort these totals and rank them. The only fields
I have in the results table are ID, Name, Date, Placement and Total.

3. Seems like it should be a simple task just to rank these totals and
place that on a form, but its tasking me pretty hard. I only have
eleven records at a time but may have more in the future.

I tried to use all the different examples from the article, but got the
same results every time. If I don't have to use a query and can put it
in code that would be best. I try to use queries as little as possible.
Any help would be greatly appreciated.

Jim

May 21 '06 #3

P: n/a
It works, Jim. Keep trying.

--
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.

"Jim" <jm*****@sbcglobal.net> wrote in message
news:11**********************@y43g2000cwc.googlegr oups.com...
Thank you for the Reply. I read through this article and tried it on my
database, no luck. It will add the records up and place that number in
the query column, but they are all the same number. Whatever the count
added up to. I've tried changing the signs around and only get addition
and subtraction from the record count. Here is how it laid out.

1. I have a table named "Results". I've used a query to add all the
totals and append them to the right place.

2. My next step is to sort these totals and rank them. The only fields
I have in the results table are ID, Name, Date, Placement and Total.

3. Seems like it should be a simple task just to rank these totals and
place that on a form, but its tasking me pretty hard. I only have
eleven records at a time but may have more in the future.

I tried to use all the different examples from the article, but got the
same results every time. If I don't have to use a query and can put it
in code that would be best. I try to use queries as little as possible.
Any help would be greatly appreciated.

Jim

May 21 '06 #4

P: n/a
Jim
Your right it works. The article left an inportant element out the
statement. here is My statement that works;

Ranking: (Select Count(*) from TblReview as placement WHERE [Total
Points] > [tblReview].[Total Points])+1

They also had the "+1" in a different place under the () on one and not
on the other. Just confuced me at first. Thanks for your help, it
enabled me to figure things out.

Jim

May 21 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.