If Statement - Two fields... 1

[nike2000]

I have two fields in a query.
They are:

PV_OverTolerance
DeltaOverTolerance

The data in the fields is either 'Yes' or 'No'.
I would like an If statement that would flag 'Warning' if any of the two fields indicated Yes for any record.

Help would be appreciated.
Many thanks,
Nike

 

[SuicidED]

Hi

SELECT IIf([pot]=-1 Or [dot]=-1,"WARNING","&quot AS warning
FROM Table1;
Ive called them pot and dot.

Regards Eddie

 

[SQLBI]

Nike,

Try the following in your SELECT statement...

SELECT PV_OverTolerance, DeltaOverTolerance, (IIF(OR(PV_OverTolerance=True, DeltaOverTolerance=TRUE),"Warning","OK")) AS Test

Not tested this so let me know how you get on.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[SQLBI]

Nike,

Sorry, using excel syntax.. change to;

(IIF(PV_OverTolerance=True Or DeltaOverTolerance=TRUE,"Warning","OK&quot) AS Test

Sorry for any confusion.

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk