4 Sep 2008, 8:35 PM
New Zenner
- Join Date:
- Aug 2008
- Posts:
- 11
- Plugin Contributions:
- 0
For those doing business in Ohio...
Searching through the messages, I've come to the conclusion that a simple zip code based search for the sales tax is not going to work in Ohio, as zip codes can span counties. I am wondering if a combination of zip code and city would give a unique tax jurisdiction?
If that were the case, the data at https://thefinder.tax.ohio.gov/StreamlineSalesTaxWeb/Default.aspx could be slammed into two tables, and I could query for zip code first, then query that recordset for a matching city name in order to get the state, county, and transit tax rates. If there are no matching cities (e.g., a misspelling), then apply the lowest rate in the zip code to be on the safe side.
Thoughts?
Owner, Randylion
http://www.randylion.com