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]
