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/Strea...b/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?