How can sales tax be formulate in a invoice

[stumped today]

I'm trying to do two things. First I built a Data bass in Access to show
suppliers , Customer, and Inventory price list. I want to be able to stick
with one program which would show sales, reciepts and keep inventory current.
Cand this be done and if so how? Second If I can't use only one program would
you suggest linking excel and access and if so would this take care of my
delema. Any suggestions would be appreciated. Oh third I need to come up
with a formula to calculate sales tax 0.95% of purchase. I'm having trouble
writing it and can't find my old book.

 

[Kassie]

Why not stick with Access, since you have already done most of the work there?

100% is 1
10% is .1
1% is .01
so .95% would be .0095

--
HTH

Kassie

Replace xxx with hotmail

 

[Bill Sharpe]

I'm trying to do two things. First I built a Data bass in Access to show
suppliers , Customer, and Inventory price list. I want to be able to stick
with one program which would show sales, reciepts and keep inventory current.
Cand this be done and if so how? Second If I can't use only one program would
you suggest linking excel and access and if so would this take care of my
delema. Any suggestions would be appreciated. Oh third I need to come up
with a formula to calculate sales tax 0.95% of purchase. I'm having trouble
writing it and can't find my old book.

Where do you live where the sales tax is only 0.95%? It's 9.75% here in
California.

Bill