I have a query similar like this to get a institutionRole field, but it is in progress sysntax, now I want to do same thing in Microsoft Access query,it seems I can only use iif, but I don't know how to do it, it has multiple arguments,
IF (ENT = "074") THEN ("MHSparent") ELSE ((IF (ENT =...