14th August 2006, 09:22 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Quote:
|
Originally Posted by lomaca
Hi CP!
I am sure it's only a matter of us, using different terminology, but would you please tell me what you mean by "rankings"?
Thanks
|
Iomaca,
Ranking by career prizemoney for example:
$1,000,000 1
$900,000 2
$750,000 3
$200,000 4
$100,000 5
etc
It can of course be done, but not easily enough for my liking and is cumbersome.
The problem is getting access to recognize the difference between two records, not between two fields.
I don't want to create a report with the info or even a query, I want to update tables, which is near impossible. Of course, I could perform a sort and then insert the ranking, but the program does not recognize a different race or venue or date as per previous / next record.
Ideally what is needed is a database that recognizes Excel formulae and can calculate between records.
At present I have a query within a query within a query, and it's getting very difficult to make changes or add queries when there are so many "layers" |