UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
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?
any 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,232
From: Devon UK



Hi
imillar 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,232
From: Devon UK



No problem 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,232
From: Devon UK



Hi
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: 27th November 2014 - 04:16 AM