[AccessD] A2K: Calculate Percentages

Darren DICK d.dick at uws.edu.au
Tue Mar 23 20:55:32 CST 2004


Hello all 
Having a brain fade here
Need to work out the Dollar amount of a percentage of a grand total

I have a combo that has values incrementing by 5 from 5 to 100 representing percentages EG 5,10,15,20 etc
If I select say...20 from that combo, that means I want to see 20 percent of a total (say...$250)
on a form eg 
So 20 percent of $250 is $50. But what is the syntax I need to do this?
EG Me.txtGrandTotal =$250.00. Me.cboPercentages = 20 So 
me.txtCalculatedPercentageOfTotal.ControlSource = What, in order to show $50.00 ????

Brain dead over here <sigh>

Many thanks in advance

Darren







More information about the AccessD mailing list