Unanswered: Populating a Category Field based on a Code Range
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.