I am trying to create a column in a query based on a Yes/No column:
IIF([column1]=0,calculation1,calculation2)
column1 being the Yes/No column. Everything I have read said this should work, but it gives me an error on the form.
I know the calculations work because I have used them in:
IIF([column2]='A' or [column2]='B',calculation1,calculation2)
Or could it be some setting in the form text box?
Thanks for any help.