Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Software Development Software Development
Search Search
Search for:
Tech Support Guy > > >

Another C Code Question


(!)

spiderman1's Avatar
spiderman1 spiderman1 is offline
Junior Member with 26 posts.
THREAD STARTER
 
Join Date: Sep 2004
Experience: Intermediate
06-Oct-2004, 08:16 PM #1
Another C Code Question
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')
)
Shadow2531's Avatar
Senior Member with 2,636 posts.
 
Join Date: Apr 2001
10-Oct-2004, 01:02 AM #2
Way too vague. You need to be far more specific.
dilip_maurya's Avatar
dilip_maurya dilip_maurya is offline
Junior Member with 6 posts.
 
Join Date: Aug 2004
Experience: Beginner
13-Oct-2004, 07:11 AM #3
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

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑