Re: IIF() please help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

hi Bruce,

I have tried this , but it won't return anything, not even if
condition is true.....

regards,
shital


BruceM wrote:
Try testing it with text:
IIf([dbo_loc]![POSTALCODE]=[TRHazardZones]![POSTALCODE],"True","False")
Does it ever show False?

"rock" <khandar@xxxxxxxxx> wrote in message
news:1150282122.009609.130350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Dear All,

I am working on a MS Access Select query where I am using an IIF()
function


IIf([dbo_loc]![POSTALCODE]=[TRHazardZones]![POSTALCODE],[TRHazardZones]![TR­ZONES],'LOW')



Output: If condition is TRUE then it works, but when condition is
false it will return nothing.


I have also tried


IIf([dbo_loc]![POSTALCODE]=[TRHazardZones]![POSTALCODE],[TRHazardZones]![TR­ZONES],"LOW")



Regsrds,
Shital

.

Quantcast