L
Linda77
I am trying to create a table and form for an order form that will eventually
be on the web. I have the sales tax rates for the counties in each of the
states in it's own table. I want to make this formula put the correct sales
tax rate in the field for sales tax rates, based on the state and then the
county. Once this is completed, I want to set a formula to only enable the
customer to select a county of the selected states that we will be collecting
sales tax for. If it is not any of the selected states (right now it is just
one state) I do not want the customer to be able to put a county in the
county field and thereby, the sales tax rate is not applicable either.
Is Access able to do this?
be on the web. I have the sales tax rates for the counties in each of the
states in it's own table. I want to make this formula put the correct sales
tax rate in the field for sales tax rates, based on the state and then the
county. Once this is completed, I want to set a formula to only enable the
customer to select a county of the selected states that we will be collecting
sales tax for. If it is not any of the selected states (right now it is just
one state) I do not want the customer to be able to put a county in the
county field and thereby, the sales tax rate is not applicable either.
Is Access able to do this?