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.

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" <jmorriz@sbcglobal.net> wrote in message
news:1147837875.708700.158840@j33g2000cwa.googlegr oups.com...[color=blue]
>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.[/color]

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

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" <jmorriz@sbcglobal.net> wrote in message
news:1148149368.886393.292490@y43g2000cwc.googlegr oups.com...[color=blue]
> 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[/color]

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