Expression in Access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to build an expression in my table so that when I type a particular
City name, the zip code of that city will automaticall fill-in in the "zip
code" field.
How do I do this. Please be very specific, as I am not an expert at
building expressions.
Thanks!
Barb E
 
Barb

First, Access tables store data. They don't work real well as a way to do
data entry. I know they look like spreadsheets, but they aren't.

Next, Access doesn't have 'triggers' that would give you a way to put a
value in one field and have some "calculated" value entered in another
field.

Third, a well-normalized table design argues AGAINST putting a (calculated
or dependent) value in a table if you already have the value on which it is
based.

Finally, my city has SCORES of zip codes. You'd be better off (but still in
trouble) putting in a zip code and looking up a city (still in trouble
because my phone book shows an example of TWO cities, both of which share
the same zip code).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I agree with using the zip code to locate the city for the reason stated. As
to your second argument, I am in that situation. My zip code covers One town
and a portion of a larger adjacent city. I live in the large adjacent city
and when I first moved here, I used the city in which I actually live. When
I got a piece of mail using the city name, I got a nastygram from the post
office saying I was required to use the Town name because the post office is
physically located in the town. So, my address is a town in which I do not
live.
Could that explain my difficulty in finding my way home?
 
Back
Top