A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

#Name?



 
 
Thread Tools Display Modes
  #1  
Old April 19th, 2005, 06:55 PM
Thrinky
external usenet poster
 
Posts: n/a
Default #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  
Old April 19th, 2005, 09:06 PM
Michel Walsh
external usenet poster
 
Posts: n/a
Default

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  
Old April 21st, 2005, 03:39 PM
Thrinky
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.