473,325 Members | 2,442 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Continous Form Records Ranking

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
4 2760
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: adolph | last post by:
I would like to add a check box to the detail area of a continous form. So that I can check on specific records, then after I've marked all the records I watn to delte, click a button to loop thru...
6
by: DS | last post by:
I have a continous form that records payments. I' starting out with a bill of lets say $10.00. What I want to happen is that when I apply a payment a new record is made. In that new record I...
2
by: Steve B | last post by:
I am trying to design a Call Log Detail form that will allow users, in a multi-user environment, to select various data/records, not necessarily in sequential order, from a subform that will, when...
0
by: gavo | last post by:
Hi. using A2K; i have a form containing a continous subform. The question is, how can i call a calculation for one of the fields in the continous subform from the main form. At the moment i...
0
by: ReidarT | last post by:
I have started to develop in vb.net. Earlier development was in MS-Access. I need a lot of continous forms to present data. The customer add and edits data in the continous form. Is use of...
5
by: valglad | last post by:
Hi, The question below was posted about 4 years ago and noone was able to answer it back then. I have virtually the same type of problem so would appreciate if anyone can help. Thanks ...
1
by: Kev | last post by:
Hi, I am trying to total a column (Shift1) in a subform (continous forms) from the after update event of the (Shift1) column control within the subform. This column stores shift codes, I want to...
3
abouddan
by: abouddan | last post by:
Hi all I am trying to create a form 'Form1' that updates my database. Fist this form is based on a query that returns all the records in table 'employe'. query1="Select id, name, salary from...
1
by: questionit | last post by:
Hi I am showing records on a continous form. I have also created a check box to appear with each record. The problem is that when ever i tick the check box, the check-boxes with other...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.