Updating a field with values in a range in

[kayjayten]

I have two tables and need to update one with data from a range held in the other.

Table 1 contains fields Premium value, Premium code.
Table 2 contains fields (Prem low, Prem high) which are the lowest and highest values for a range, and a third field (Prem code).

I need to add the relevant Prem code from Table 2 into the Premium Code field in Table 1 where the Premium value falls within a particular range.

I'm hoping there's a simple answer to this...