AND function in QV?

[#1]

Hello Everyone,

I am quite new in developing tabs in QV and now I am facing a challenge: I can't find an equivalent of the excel function AND in QV, same thing for OR.

Can someone help me on this ?

Many thanks for your efforts

[SunilChauhan · Accepted solution]

if( field=1 and field=2 ,'Hello')   for and

if( field=1 or field=2 ,'Hello')   for or

or in load

Load *

from path where  field=1 and field=2;

Load *

from path where  field=1 or field=2;

hope this helps

[#3]

Thanks to a combination of the two I got what I was looking for !!! Many thanks for your help and have a nice day