I would like to create a query were I can check to see if the 2nd part(tab 2) of the audit on my form has the same Employee name as the 1st tab and/or if the name is null but the audit was been done by the same employee on the 1st tab and the checkbox marked to reflect such.
I don't know how to write the query:
TotalCount: iif([Empl2Name(tab2)= EmployeeN(tab1),[TotalP],0) but how would I write the second part of the query?
I need an OR statement where I can say " OR if the [Empl2Name] is null and [CaseCcheck] is true,[TotalP],0)
As you can see this lady needs some help.
I don't know how to write the query:
TotalCount: iif([Empl2Name(tab2)= EmployeeN(tab1),[TotalP],0) but how would I write the second part of the query?
I need an OR statement where I can say " OR if the [Empl2Name] is null and [CaseCcheck] is true,[TotalP],0)
As you can see this lady needs some help.
