More Dumb Access Questions

[Cliff]

All,

Am trying to set up a query that uses some positive factors from HTR but eliminates any horses not in the top half of HTR ranking. I've set up a column and defined it as tophalf:[nFLD/2]+1. This seems to be calculating and working fine.

However, when I set up an expression "eliminate" with criteria of rHTR<=tophalf, this part does not work correctly.

Any suggestions? Hopefully I explained this well enough.

Thanks for your help,
Cliff

[Rick]

Try putting < ([nFLD]/2) +1 in criteria field of HTR.

Of course I am referring to the rHTR field.

[Cliff]

Thanks RickS,

That worked great! Unfortunately, didn't help the numbers much.