How do I select data based on presence of other data?

[SimonPGreen]

Hi all,

Have a table containg following fields:

strPackageName String
intApplicationNumber Integer
curForecast Currency
curValue Currency
curCertified Currency

Is it possible to build a select query that lists strPackageName,intAppcationNumber and either curCertified, curValue or curForecast conditionally i.e If curCertified > 0 use it else if curValue > 0 use it else use curForecast.

Any help greatly appreciated.

Regards

Simon

 

[PHV]

Something like this ?
SELECT strPackageName, intApplicationNumber,
IIf(curCertified>0,curCertified,
IIf(curValue>0,curValue,curForecast)) AS myCurrency
FROM yourTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SimonPGreen]

Thanks PH - Just the job