Do I need a state / jurisdictions table?

[algioia]

We receive client data monthly and it includes information on sales. I need to be able to import their data each month into a database and run a sales total for a particular jurisdiction in a state. For example, I need all sales for 1/1/08 through 12/31/08 in Houston, TX. I don't even know where to begin (haven't used Access in 10 years!).

Do I need to create a "state" table to be able to query by state?
I'll need to read up on how to link the tables together. I tried doing a simple query by state with a from and to date but the query came back with no results. I've spent hours on this already and it's all so overwhelming. If you have any suggestions, quick tips, any info I could use, please send it my way! If not, please just let me know if I will have to create a table for states and jurisdictions in order to run these reports.

Any help is appreciated!

Thank you!
annette

 

[Kryst51]

Do I need to create a "state" table to be able to query by state?

Not necessarily, but having one could benefit you, as it can save time in retyping the state name always, also, it helps reduce errors in spelling during retyping. If you would post more about your query, or even a sample db zipped would be great as then more specific help could be given.

I'll need to read up on how to link the tables together.

One word of advice. A lot of beginners teaching, especially books, talk about linking tables through lookup fields at the tables level; but this is a poor way to link your tables. I suggest using the relationship view to link your tables together. Then in forms you can makes the lookups you need with combo boxes.

 

[wazz]

if you need, there are websites and sample dbs around that supply complete lists of states, countries, etc. you could even copy data from a web page if necessary. also, some people use zip codes as their 'locator'. search these forums for samples and other ideas.