More Criteria questions

[Lee Carson]

This is painful - but here goes The field: nLAY Table All-HX4 Total MAX
What I want to do is have the layoff only show records within a =<90 day period. Do I write code in the Field or the Criteria and what would this code look like?
Lee

[Lee Carson]

I also wanted to to shoe the max SOR within that 90 day layoff period - two things
Lee

[MikeDee]

Lee

the first one is easy, in the design of your query in the column with the nlay field you put <=90 in the first creteria box. When you run the query you will only see records where the horses have run in less then 90 days.

Keep in mind that a 0 qualifies here because a 0 is used for the lay of a first time starter. Perhaps you want to consder >0 and <=90?

if you do jsut put >0 and <=90 in the creteria box


Your second question is tougher.

SOR is not in the hx4 export.

item 14 EPR is in the export is this the item you want to use the max function on?

[tbrown]

SOR would be a handy addition to the exports....maybe Hx5?
I was looking all over for it the other night when it dawned on me I was SOL! :p