Rank Class = 1 or 2 : Meaning

[Sheets Guy]

When I run a Robot query the results on the :LEARN ALL" for Class =1 or Class =2 is very different from when I export the data to ACCESS and use rCLASS <=2. I mean it's a dramatic difference making a proiftable spot play in Robot unprofitable run in Access?

Any ideas? I must be missing something...:(

[km]

Class < =2 also includes all the horse rank = 0, and they are numerous with the class rank (0= no rank, such as a FTS)

change that query to rClass > 0 and rCLass < 3 and you'll get the match with the Robot

[Sheets Guy]

Class < =2 also includes all the horse rank = 0, and they are numerous with the class rank (0= no rank, such as a FTS)

change that query to rClass > 0 and rCLass < 3 and you'll get the match with the Robot

Never thought of that one. I guess that's why I call on the experts in situations like these. :)

Thanks KM.