Query Criteria

#1 (**permalink**) 28-Jul-2006, 08:28 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12329-query-criteria.html
Thanks in advance
wal50
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12329

*

#2 (**permalink**) 28-Jul-2006, 08:28 AM

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

"wal50" wrote:

> 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12329
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12329
> The field is numeric.
> Nothing seem to work.
> Any ideas are appreciated.
> Thanks in advance
> wal50

#3 (**permalink**) 28-Jul-2006, 08:28 AM

If MyField <> 200 then
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12329
if MyField >= 30 AND MyField <= 39 then
Run the Query ...
end if
end if

--
-Larry-
--

"wal50" wrote in message
news:91CDCF88-92F0-48C7-8DFE-426AF4281A88@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12329
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

#4 (**permalink**) 28-Jul-2006, 08:28 AM

Works Thanks

"Larry Daugherty" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12329

> If MyField <> 200 then
> if MyField >= 30 AND MyField <= 39 then
> Run the Query ...
> end if
> end if
>
> --
> -Larry-
> --
>
> "wal50" wrote in message
> news:91CDCF88-92F0-48C7-8DFE-426AF4281A88@microsoft.com...
> > 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:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12329
> > <> 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
>
>
>