Crosstab and values

[rob.lyles]

Hi, I have a crosstab query that I only want to return a value < 1 .75 from the table it is looking from. In other words, if it exceeds 1.75 then I need to say NA, and if it is less than 1.75, I need to display what it found. How can I do this?

Thanks

 

[namliam]

How would you do it in a normal query? Solve the problem in a normal query, solve it in the Crosstab.