#Name?

T

Thrinky

Hello,
I am trying to write a query that will provide me with any results that are
outside the range of 6.0 - 28.0. The result field is 'Text' and contain value
like none, clear etc.. I wrote a query but when I run it, it gives me #Name?
in all columns.

SELECT A, B, C, D
FROM XYZ
WHERE A Like "CORT*" AND VAL(ReSULT) not between 6 and 28;
Thanks
 
M

Michel Walsh

Hi,


have you tried


... AND NOT( VAL(result) BETWEEN 6 AND 26)



Hoping it may help,
Vanderghast, Access MVP
 
Top