I would like to calculate the tax on a product. widget sells for 10.00, the tax is .0825. I can't seem to get it right.
Would someone point me in the right direction.
Thanks
Lon
I would like to calculate the tax on a product. widget sells for 10.00, the tax is .0825. I can't seem to get it right.
Would someone point me in the right direction.
Thanks
Lon
I'm not a fan of storing a calculated field in a table but you want to query
TotalPrice: priceFieldName * 1.0825
Thats what you would enter under the Field: section in the query design view.