Points for placings - best method

[Hugh self taught]

Hi All,

I'm about to add a points table & capture form to my database & I'm trying
to be sure in my mind what would be the easiest & best way of performing the
calculation. I will look up up the "couple" from one table then enter their
placing 1 through 8. The points that currently get allocated is 5 through 8
get 5 points. 1st = 25, 2nd = 20, 3rd = 15 & 4th = 10. The number of couples
will vary from min 3 to max 8.

How would I best go about structuring & coding that? Any suggestions?

 

[John W. Vinson]

Hi All,

I'm about to add a points table & capture form to my database & I'm trying
to be sure in my mind what would be the easiest & best way of performing the
calculation. I will look up up the "couple" from one table then enter their
placing 1 through 8. The points that currently get allocated is 5 through 8
get 5 points. 1st = 25, 2nd = 20, 3rd = 15 & 4th = 10. The number of couples
will vary from min 3 to max 8.

How would I best go about structuring & coding that? Any suggestions?

The simplest would be to have a little scores table with two fields, Placing
(values 1 to 8, or more if need be) and another for Score. You could simply
create a query joining your placing field to the placing field in this table.

The one question I'd have would be - are there ever ties? How do you score
them if so?

 

[Hugh self taught]

Thanks for that John, I will experiment tonight. I'm not sure if I should
start a new thread but come June that scenario will change. Points will be
allocated from the bottom up. Couples placed 5th through 8th will always only
get 5 points each. However 1st through 4th is changing to allocate from
bottom up. ie if only 3 couples competed 3rd would get 10 points, 2nd = 15 &
1st = 20 as opposed to my initial scenario.

I might be able to add another field for "count" & use dcount to determine
the number of couples danced to point to the correct points allocation?

Your suggestion please.

 

[John W. Vinson]

On Sun, 22 Mar 2009 23:27:00 -0700, Hugh self taught <Hugh self

Thanks for that John, I will experiment tonight. I'm not sure if I should
start a new thread but come June that scenario will change. Points will be
allocated from the bottom up. Couples placed 5th through 8th will always only
get 5 points each. However 1st through 4th is changing to allocate from
bottom up. ie if only 3 couples competed 3rd would get 10 points, 2nd = 15 &
1st = 20 as opposed to my initial scenario.

I might be able to add another field for "count" & use dcount to determine
the number of couples danced to point to the correct points allocation?

Bear in mind... we're not there. We have no way to know even what the problem
space is (competitive dancing I gather...?); we have no way to know how your
tables are structured.

But my suggestion of a scores table is even more relevant given this change -
since you can simply edit the scores in the table to reflect the change. Yes,
you can use DCount() or a Subquery to count couples; I'm not certain how this
would be written because (again) I can't see your tables.