[AccessD] A2K: Currency as a percentage

Darren DICK d.dick at uws.edu.au
Mon Nov 8 22:52:48 CST 2004


Hey Deano
Thanks Gustav and Deano

You guys are legends

I have done it a million times - but it's one of those copy and paste deals
for me
I neven learn that stuff - toooooo sanguine :-))

See ya'll
Many thanks again
DD


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dean Ellis
Sent: Tuesday, 2 November 2004 10:10 PM
To: Access Developers discussion and problem solving
Subject: RE: [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

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




More information about the AccessD mailing list