Ok, new subscriber that I am, I'm hoping one of you
geniuses out there can help this novice FOXPRO for
DOS 2.6 user.
I want to do a report for our football team for a database
that I set up. I'd like the report to return simple info
(names, fields, etc.) that even I can figure out. The
tricky part is that I want to have the values entered for
each field ranked in relation to the other players in that
field, then to use that ranking as a value for a final
calculated field to give an overall team rank (each field
value is weighed then multiplied by the where the player
ranks in that field, then they are added together and
averaged).
I envision it to look somewhat like:
Name Bench Squats 40 time Overall Rank
First Guy
values 325 345 4.4
rank 12 11 2 12
Second Guy
values 350 450 5.0
rank 9 7 10 16
Another Guy
values 400 500 5.1
rank 6 4 11 15
ETC. ANY help you can give me will be greatly appreciated.
Pointers?
Thanx!
Barb