[AccessD] A2K: Currency as a percentage

Dazza,

The formula is fairly simple. Just divide 5 (being the percentage) by 100
and multiply it by the dollar amount. This will give the percentage og the
dollar amount in dollars.

Putting it into context.

Percent field = txtpercent
Dollar field = txtdollar
discount field = txtdiscount

txtdiscount = txtdollar * (txtpercent/100)

Cheers

Dean

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK
Sent: Tuesday, 2 November 2004 9:46 PM
To: AccessD List
Subject: [AccessD] A2K: Currency as a percentage


Hello all

Can never remember how to do percentages off the top of my head <sigh>

I have a a form that allows users to put in any Dollar amount for a discount
I also want to put in another txtBox and allow users to type in say...5 and
have the machine calculate discounts in Dollars from the "5" value

Thus have access caculate (in this case) 5 percent of the whole and then put
that currency amount (EG 5% of $100.00 = $5.00) of $5.00 in the discount
field

Make sense?

many thanks in advance

Darren

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com