[AccessD] A2K: Calculate Percentages

Stuart you da man
My maths (and maths abilities) are just crap
Thank you so much (again)

Darren


----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problemsolving" <accessd at databaseadvisors.com>
Sent: Wednesday, March 24, 2004 2:00 PM
Subject: Re: [AccessD] A2K: Calculate Percentages


> On 24 Mar 2004 at 13:55, Darren DICK wrote:
> 
> > 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 ????
> > 
> 
> Me.txtGrandTotal * Me.cbiPercentage / 100
> 
> (Percentage mean "out of a hundred" - so just dividing by 100 gives 
> you  1%)
> 
> 
>  
> -- 
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
> 
> 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com