G
Guest
How do you join two iif statements into one? i have two iff statements, the
first being
NewDate: IIf([New]=[Saturday],[Monday],[New])
and the second being
NewDate: IIf([New]=[Sunday],[Monday],[New])
I would like these in the same field of my query, so I won't have to have
two separate queries, one for each iif statement. How do I do this?
first being
NewDate: IIf([New]=[Saturday],[Monday],[New])
and the second being
NewDate: IIf([New]=[Sunday],[Monday],[New])
I would like these in the same field of my query, so I won't have to have
two separate queries, one for each iif statement. How do I do this?