IIf - if value in field A is zero use column B content, otherwise content of field A

[Steve Hughes]

Being new to Access I need to do the IIF calculation as per the title, if value in field A is zero use column B content, otherwise content of A. I haven't had any success, can anyone give me the syntax? At the moment I'm exporting to Excel and importing the result.

[June7]

Why haven't you had success, what have you tried?

IIf([A]=0, [B], [A])

[Steve Hughes]

Many thanks for that and it works ok. I tried many things but couldn't get it to work and couldn't see a sample in any of the googled links. Looks easy now you show it in a simple form.