Expression in Access table

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

"Barb E." Barb wrote in message
...
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

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?
--
Dave Hargis, Microsoft Access MVP


"Jeff Boyce" wrote:

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

"Barb E." Barb wrote in message
...
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

Yes, I'm sure that's it, Dave. We'll stick with that story...

Jeff

"Klatuu" wrote in message
...
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?
--
Dave Hargis, Microsoft Access MVP


"Jeff Boyce" wrote:

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

"Barb E." Barb wrote in message
...
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