I am working in a query specifically the IIF statement below. Where the
five CCCCC are I want it to be number. So if the login is not equal to five
numbers then flag as new else null. Can you help.
New Employee: IIf([Login]<>"CCCCC","New","")
--
Message posted via http://www.accessmonster.com