HOW TO ENTER RANGES OF DATA INTO A TABLE IN ACCESS

[Ed]

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

 

[Gina Whipp]

Ed,

I think you are talking about several tables BUT you need to tell us what
you are trying to do. For instance, are you trying to find locations within
a certain radius of a zip code? OR what states or provinces are in a
territory? OR maybe you just want to know what zip codes are in a
particular state or territory? AND are we talking US or US and Canada?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Philip Herlihy]

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