Criteria needed when specific data in one field, populates a value in another field

[Ian Frost]

What is the criteria needed to have specific data entered in one field and have it populate data in another field.



My example.

Type of Leave: Multiplier:
Leave with out Pay (LWOP) 1.00
Leave with out Pay 1/2 (LWOP 1/2) .50
Vacant 1.00
Worker's Comp .75

When the type of leave is determined for a specified employee, I would like the multiplier field to display the corresponding value.

In the end there is a calculation for frictional savings = daily rate * multiplier * total working days absent.

Thank you for your help

[ranman256]

use an update query to update the field:
update [field] from table1 where table2.keyId = 321

usu you use the record key a criteria.