Recent content by TomH71

The error I received was "Compile Error: Syntax Error"

First of all thank you for your help. Using you advice, I managed to get the first selection to work with this code. It returned the value of 8.68. Worker1Rate = IIf(Nz(Worker1 = 1), DLookup("SiteLead", "WageRates", "JobNumber=" & [JobNumber]), "") HOWEVER... Nesting the IIF caused me...

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...

Hi, My name is Tom and I am from Minnesota and relatively new to Access. My employer recently assigned me the task of creating an Access database for our company and I am learning as I go. My progress up to this point has been slow but steady - but now I am stuck. :banghead: Thanks in...