I'm trying to create a nested IIf Dlookup without success.
Here is my form.
I am trying to look up a wage rate for a particular Job Number based on a drop down list on a form but... the formula needs to reference the field in a table that matches the selected drop down.
So if I select...