UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Calculating Tax Formula in Access 2007    
 
   
stokey18
post Feb 20 2009, 10:29 AM
Post #1

New Member
Posts: 16



Hi, I am trying to create a formula to calculate the price of an existing field plus tax. Say tax is 15% in excell I would use the formula........ =sum(cell number/100)*115 how can I create the same formula in access?

Many thanks,

Ben.
Go to the top of the page
 
+
Alan_G
post Feb 20 2009, 10:33 AM
Post #2

Utterly Yorkshire and Forum/Wiki Editor
Posts: 16,058
From: Devon UK



Hi

Simillar kind of thing......in the Control Source of an unbound text box

=[NameOfExistingControl] + ([NameOfExistingControl] * 0.15)
Go to the top of the page
 
+
stokey18
post Feb 20 2009, 10:37 AM
Post #3

New Member
Posts: 16



That works a treat, thanks a million!
Go to the top of the page
 
+
Alan_G
post Feb 20 2009, 12:40 PM
Post #4

Utterly Yorkshire and Forum/Wiki Editor
Posts: 16,058
From: Devon UK



No problem (IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
Alan_G
post Feb 20 2009, 03:27 PM
Post #5

Utterly Yorkshire and Forum/Wiki Editor
Posts: 16,058
From: Devon UK



Hi

I just had a thought about your post - hard coding tax rates (especially things like VAT) is never a good idea, as when the VAT rate changes you have to go and edit every occurence of your hard coded rate. You're better off having a look up table for rates.........

Have a look here for a recent thread on the topic
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 18th April 2014 - 08:48 AM