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