U Unicon Registered User. Local time Today, 20:13 Joined Dec 24, 2009 Messages 123 Jan 13, 2011 #1 Dear All, I have a query as attached I just want to show "yes" in a 4th field, if all 03 field (HS, MOFA, Ambe) value is True ("Yes"). Your great idea will be appreciated. Attachments untitled.bmp untitled.bmp 44.7 KB · Views: 93
Dear All, I have a query as attached I just want to show "yes" in a 4th field, if all 03 field (HS, MOFA, Ambe) value is True ("Yes"). Your great idea will be appreciated.
V vbaInet AWF VIP Local time Today, 16:13 Joined Jan 22, 2010 Messages 26,328 Jan 13, 2011 #2 Expr1: IIF([HS] = Yes And [MOFA] = Yes And [Ambe] = Yes, Yes, No)
