Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Query Criteria

Discussion in 'Information Technology' started by wal50, Jul 28, 2006.

Tags:
  1. wal50

    wal50
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. wal50

    wal50
    Expand Collapse
    Guest

    (<>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.
    > The field is numeric.
    > Nothing seem to work.
    > Any ideas are appreciated.
    > Thanks in advance
    > wal50
     
  4. Larry Daugherty

    Larry Daugherty
    Expand Collapse
    Guest

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

    --
    -Larry-
    --

    "wal50" <wal50@discussions.microsoft.com> 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:
    > <> 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
     
  5. wal50

    wal50
    Expand Collapse
    Guest

    Works Thanks

    "Larry Daugherty" wrote:

    > If MyField <> 200 then
    > if MyField >= 30 AND MyField <= 39 then
    > Run the Query ...
    > end if
    > end if
    >
    > --
    > -Larry-
    > --
    >
    > "wal50" <wal50@discussions.microsoft.com> 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:
    > > <> 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

    >
    >
    >
     

Share This Page