Query Criteria

[wal50]

I want to query a file if a field is <> 200 and <>between 30 and 39.
I get a syntax error. It doesn't seem to like the <>Between N and N. Is
this not allowed?
I have tried:
<> 200 and <>between 30 and 39 against one field
and each element separately.
The field is numeric.
Nothing seem to work.
Any ideas are appreciated.
Thanks in advance
wal50

 

[wal50]

(<>200 and <30) or (<>200 and >39) works but how come the <>between doesn't

 

[Larry Daugherty]

If MyField <> 200 then
if MyField >= 30 AND MyField <= 39 then
Run the Query ...
end if
end if

 

[wal50]

Works Thanks

If MyField <> 200 then
if MyField >= 30 AND MyField <= 39 then
Run the Query ...
end if
end if