Thanks Shoto,
Yes, I'm aware of that method, but it is very very slow and cumbersome when dealing with 2gb of data. I also try to keep the speed of Filemaker as fast as possible by having all calculations done in Access prior to import.
Thanks for the suggestion though.
Quote:
|
Originally Posted by Chinbok
CP,
Read the article last night which has helped a little. I can now rank all horses in the table. Still not sure how to make it differentiate between races in the table. Is there a mrexcel.com equivalent for Access or SQL?
Cheers
|
Chinbok,
That is the trick, the differentiation between races.
Here is some help:
Rank: (SELECT COUNT (*) FROM QrySTAKES WHERE QrySTAKES.STAKES > QrySTAKES1.STAKES And DATE=QrySTAKES1.DATE And TRACK=QrySTAKES1.TRACK And RNO=QrySTAKES1.RNO)
This is the calculation I use for ranking horse prizemoney.
QrySTAKES is a query based on date track race horse prizemoney.
QrySTAKES1 is the alias of QryStakes.
QrySTAKES MUST be sorted date ascending, track ascending, race ascending,prizemoney descending.
You won't find much help out there on doing this, as nobody knows or could be bothered finding the answer,believe me I've posted on every Access forum there is internationally, all they do is tell you how to rank a set of records, not within the set like we need.
So I came up with my own derivation by trial and error.