How to use IF statements in query

[Ben2k]

I have a query with a field called "VatQualifying", the value of this is always either 0 or 1 i.e. yes or no

If it is 0 I want my query to display "No" instead of 0
If it is 1 I want it to display "Yes" instead of 1

How can I do it?

Thanks

Ben

 

[Norie]

Try this

Iif([VatQualifying], "Yes", "No")

BTW

Does VatQualifying come from a table? If so you could change it's data type to Yes/No.

 

[Ben2k]

Yes comes from a table however its a linked paradox table so unable to change data type.

Just noticed as well the values or 0 for No and -1 for Yes, will your expression still work?

Cheers

Ben

 

[Norie]

As far as I know it should.

Syntax for IIf is

IIf([Expression], X, Y)

means

if Expression is True return X
if Expression is False return Y

Access regards -1 as True and 0 as False.