add data in field based on value of data in another field

[Guest]

How do I populate a field with data based on the value of the data in another
field of the same record? For example, if the zip code is between 80300 and
80400, the region equals Boulder.

 

[Smartin]

How do I populate a field with data based on the value of the data in another
field of the same record? For example, if the zip code is between 80300 and
80400, the region equals Boulder.

You don't really need (read: should not have) another field in the same
table, but if you are looking for a way to look up the LoacaleName of a
ZIPCode in MyTable you will need a separate table containing all the ZIP
codes and locale names (available via Googling) and a little query like

SELECT LocaleName From ZIPCodeTable Where ZIP = MyTable.ZIPCode;