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: 15
Joined: 29-February 08



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,259
Joined: 12-January 03
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: 15
Joined: 29-February 08



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,259
Joined: 12-January 03
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,259
Joined: 12-January 03
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
 


RSSSearch   Top   Lo-Fi    27th January 2015 - 07:23 AM