1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Another C Code Question

Discussion in 'Software Development' started by spiderman1, Oct 6, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. spiderman1

    spiderman1 Thread Starter

    Joined:
    Oct 1, 2004
    Messages:
    26
    I want to look at records GT 84 and LT 420 with a Loan_type Not Equal to 'ST'.

    When I use this code below, it doesn not work.

    It seems to give me only records with a loan_type equal to 'ST'.

    Any ideas on how to fix this?


    (
    (( DATE_OPENED GE 85 ) OR
    ( DATE_OPENED LE 420 )) AND
    ( LOAN_TYPE NE 'ST')
    )
     
  2. Shadow2531

    Shadow2531

    Joined:
    Apr 30, 2001
    Messages:
    2,636
    Way too vague. You need to be far more specific.
     
  3. dilip_maurya

    dilip_maurya

    Joined:
    Aug 28, 2004
    Messages:
    6
    since u want records GT 84 and LT 420..........

    Then why this condition ................
    (( DATE_OPENED GE 85 ) OR ( DATE_OPENED LE 420 ))
    This condition will return all the records greater than equal to 85 as well as
    all the records less than equal to 420..........which actually makes up ur entire recordset

    Try this insted........
    (( DATE_OPENED GE 85 ) AND ( DATE_OPENED LE 420 ))
    This condition will return all the records greater than equal to 85 and
    all records less than equal to 420............which is records between 85 and 420 only
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/281863