G
Guest
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
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