O ootkhopdi Registered User. Local time Today, 11:14 Joined Oct 17, 2013 Messages 181 Nov 21, 2013 #1 i have n text box on main form which contain sum of diff.fields.. i want to set maximum value as 1000 or sum of diffrent fileds how can i do it
i have n text box on main form which contain sum of diff.fields.. i want to set maximum value as 1000 or sum of diffrent fileds how can i do it
M Mihail Registered User. Local time Today, 07:44 Joined Jan 22, 2011 Messages 2,373 Nov 21, 2013 #2 = IIF(Sum1 <= 1000, Sum1 , Sum2)
