Ed said:
How does one enter ranges ie. zip code ranges into a access table also how
does one enter multiple values ie states for one territory into an access
table?
Thank you
Ed
It isn't clear what you mean. If you're talking about how to load a lot
of information into an Access database without typing it into a table or
(better) a form, then you can import from many "regular" formats,
including Excel.
The second part of your question sounds different: a many-to-one
relationship. You'd have one table for "territory" with a unique ID
(primary key) and another table for "state" which included the key of
the relevant territory. A "relationship". Google for "normalisation"
to learn more.
Phil, London