how to use IF fun in Query

[krunalprajapati]

I want to use IF function in query. or there may be another function like IF which can be used in query.
(if any one know the DECODE function of SQL than i want a function like that in access' query)

plz. help

krunal

 

[aleb]

if = iif in Access

 

[Rich]

Iif, Switch and Choose are very similar

 

[krunalprajapati]

Thanks both of u...

i got my right answer