How to add additional column to existing table and backfill data

[csenor]

Hello forum. I have an Access table with about 1000 records. I now have the need to categorize an existing field by local, county, or state. When I add a blank column, what kind of query and what's the procedure to back fill the existing records without me having to go through line by line and inserting the information? If this was Excel, a simple vlookup formula would work, but I'm stumped when doing it in Access. Thank you.

 

[xenou]

You can add a column using table designer - the same as you would when creating the table.
For updating data, you will use an update query but sounds like you will need a lookup table in order to match fields to proper values.