If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Name?
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 |
#2
|
|||
|
|||
Hi,
have you tried ... AND NOT( VAL(result) BETWEEN 6 AND 26) Hoping it may help, Vanderghast, Access MVP "Thrinky" wrote in message ... 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 |
#3
|
|||
|
|||
I just tried and it works.
Thanks alot. "Thrinky" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|