Using Access to find specific K Top-2 races

[ggpagels]

I found a good way to screen daily races for KM’s K top-2 horses presented in the November HTR Newsletter. In Access build a query using a table created from the HX4 export with tDATE, tTRK, nRACE, rKrat, nKrat, nKGAP with rKrat=1. Also create a field based on the calculation expression [nKrat]+([nKrat]-[nKGAP]). The result of the calculation will be the sum of the K1 and K2 K rating numbers. The expression field can then be filtered by any threshold you want (i.e. >=220 to find races with a K top-2 win probability of 66%). :D

[HBee]

Jerry,

That is a neet way to get it done. I was looking at a much more complex way.

Thanks

Herman