Search results

Where does this resulting value appear? In terms of using it in an iff statement would it be something like: Iif Me.textlocation = 'Slough' then do Slough address else do London address? Or a similar concept but in a case statement (as Mr B suggested)