Conditional calculations in a query 2

[santastefano]

Is it possible to insert the equivelant of an IF - THEN statement into a query calculation, something like:
If [FieldName]= false then.... else .....
All efforts so far failed.
Thanks in advance for any advice

 

[ZmrAbdulla]

See IIf Function in the help.

IIf(expr, truepart, falsepart)

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[TheAceMan1]

How are ya santastefano . . .

In VBE help have a look at the [blue]IIf[/blue] function . . .

See Ya! . . . . . .

 

[santastefano]

Thanks to both.
Complete & SPEEDY