database for sales tax

ECOOK

unread,

Jun 9, 2007, 8:08:55 AM6/9/07

to

Hi,
I 'm working on the creation of a database for sales tax
for all states in the USA.

I do not want to "re-created the wheel" if anyone already has this database
, send me a copy.

In access 2003

thanks
ella...@comcast.net

Barry Edmund Wright

unread,

Jun 9, 2007, 9:30:56 PM6/9/07

to

Create a database with one table.
Fields are:
Auto Increment
strStateAbbrev i.e. NY
strStateDesc i.e. New York
lngStateTax .05 (or whatever)

Fill in the table.
Oh did you want someone to fill in the data for you?

Cheers,
Barry

> ellac...@comcast.net

Larry Linson

unread,

Jun 9, 2007, 10:07:24 PM6/9/07

to

"ECOOK" <fun...@comcast.net> wrote

> I 'm working on the creation of a database
> for sales tax for all states in the USA.
>
> I do not want to "re-created the wheel" if
> anyone already has this database, send me
> a copy.

How do you plan to handle states where localities have some latitude in
deciding how much they are going to tax, as part of the general sales tax?

FYI, in Texas, you'd need to get the tax rates from the Comptroller of
Public Accounts. And, different localities do tax different amounts. And,
that does change whenever the locality decides to change it. So you'll need
to figure out, too, how and how often you get fresh data and update.

Larry Linson
Microsoft Access MVP

missinglinq via AccessMonster.com

unread,

Jun 10, 2007, 10:14:05 AM6/10/07

to

As Larry has suggested, this project is going to be a real hairball! On top
of the "states with localities that have latitude" problem and the constant
changing of rates, you also have states where there are different sales taxes
depending the sales items (food, clothing, medicine etc.) This is really not
a one-person, run-up in a day/week/month, type of application; this is a
constantly-changing ongoing project

If you're doing this for an employer the only sane thing to do is to advise
them to subscribe to a service. There are a number that have a setup fee for
the software then a modest monthly fee for updating service.

If this is for a school project, go back and pick another project!

Either way, good luck!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200706/1

ECOOK

unread,

Jun 15, 2007, 6:04:05 AM6/15/07

to

Access will provide a reporting tool for sales tax only

"Larry Linson" <bou...@localhost.not> wrote in message
news:w1Jai.488$or4.53@trnddc06...

ECOOK

unread,

Jun 15, 2007, 6:22:30 AM6/15/07

to

what about a template
for sales tax like the one for order entry

information will be imported of course

Thanks
Ella

"Larry Linson" <bou...@localhost.not> wrote in message
news:w1Jai.488$or4.53@trnddc06...

ECOOK

unread,

Jun 15, 2007, 6:23:03 AM6/15/07

to

looking for a template

thanks
ella

"Barry Edmund Wright" <bwright_...@sympatico.ca> wrote in message
news:1181439056....@k79g2000hse.googlegroups.com...

ECOOK

unread,

Jun 15, 2007, 6:25:20 AM6/15/07

to

thanks
the tax issue complex -yes,
however, if you have a template, where importation is possible that would
be great

"missinglinq via AccessMonster.com" <u28780@uwe> wrote in message
news:737e3ce1b3a25@uwe...

ECOOK

unread,

Jun 16, 2007, 7:40:18 AM6/16/07

to

Larry Linson, Microsoft Access MVP

part 1, setting up exemption database with copies of exemption

Access, instead of picture of employee a picture of exemption
certicificate