U Unicon Registered User. Local time Tomorrow, 00:13 Joined Dec 24, 2009 Messages 123 Jul 29, 2010 #1 Dear All, How can I show the percentage for below? Total = 1183 A = 250 B = 350 C = 155 A - % of total B - % of total C - % of total Please advise.
Dear All, How can I show the percentage for below? Total = 1183 A = 250 B = 350 C = 155 A - % of total B - % of total C - % of total Please advise.
John Big Booty AWF VIP Local time Tomorrow, 07:13 Joined Aug 29, 2005 Messages 8,243 Jul 29, 2010 #2 Generally (Value A)/(Total)*100 will return the percentage value. On a Form you could have a control with the Control Source = Me.FieldA / Me.Total * 100
Generally (Value A)/(Total)*100 will return the percentage value. On a Form you could have a control with the Control Source = Me.FieldA / Me.Total * 100
U Unicon Registered User. Local time Tomorrow, 00:13 Joined Dec 24, 2009 Messages 123 Jul 29, 2010 #3 Thaks John Big Booty, Got it.