U Unicon Registered User. Local time Today, 15:17 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: 92
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, 11:17 Joined Jan 22, 2010 Messages 26,328 Jan 13, 2011 #2 Expr1: IIF([HS] = Yes And [MOFA] = Yes And [Ambe] = Yes, Yes, No)
