I have two tables the first of which contains transaction data and has an account code.

The second table stores various ranges of codes and provides an Account Category - I need to populate a blank Account Category field in table 1 (based on the account code of the transaction) with the correct Account Category form table 2 so that they can be grouped later.

(Currently I do this in Excel files with various If statements but the number of files are growing so thought I'd try and do this in Access)

Is there a simple way to do this E.g through an Update Query?

I can create lots of queries from table 1 to identify the records but wanted to try and solve the problem with fewer steps.

Any ideas on how best to approach this?