[MS_AccessPros] Sales Tax calculation

 

Hello friends,

I need to calculate sales tax which is a percentage of a purchase total. I want to store the sales tax percentage in a table. Here is my formula but it is not working.

=Round(([LaborPrice]+[MatPrice]+[DeliveryChg])*[tblSalesTaxRate]![SalesTaxRate],2)

What is the correct way to reference the value in the SalesTaxRate field of my table?

Doyce

__._,_.___

---

Posted by: winberry.doyce@roadsysinc.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___