So first, you must decide on whether or not a city or county sales tax is applicable. For instance here in Florida each county has a different State Sales Tax and State Gasoline Tax. Assuming that's not a consideration, I'd build a table for the recordset to call upon with the following fields: tblStateTax TaxID - Primary Key (Autonumber) State - Text TaxStart - Long TaxEnd - Long TaxRate

I'm going to assume that your dates are not real date datatypes since the way you are formatting them is useless to SQL. I would probably build a function and call it in a query or as the controlsource of a textbox in a form or report. Either use a recordset to get the State data from a table, or just use a Select Case statement. Personally, I'd prefer the recordset because it is more

Received From: IP 87.8.213.91 host91-213-dynamic.8-87-r.retail.telecomitalia.it (at dnsti.interbusiness.it) Spamvert phish: businessbanking.53.com.session2207857.psdrr.tk IP 211.43.204.122 (at ns2.lgdacom.net / kidc.net / KOREA) Much More Fifth Third Bank sightings: http://groups.google.com/groups/search?q=%%22Fifth+Third+Bank%%22+group%%3A*abuse&start=0&scoring=d& More info below:

Received From: IP 211.236.137.62 (at ns2.tachynet.co.kr / cj.net / DACOM / bora.net) Open Proxy (pxychain) - 1099816804 (Sun Nov 7 09:40:04 2004) http://njabl.org/cgi-bin/lookup.cgi?query=211.236.137.62 More info below: ==================== X-SID-PRA: Alan <zyqy_kevil@ituqjn.com> X-Message-Info: txF49lGdW414e1e8gPnwt1mtz7/ea9QMH/R3pAP5/kQ= Received: from tomts12-srv.bellnexxia.net (