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.
Last edited: