Hi
i want to result as dlookup function in access 2007
when i use dlookup like this
=DLookUp("GPFDed","[SalaryAll]","[EMPID]='" & ![Cmb_EMPID] & "' And [SalMonth]='" & "Jan" & "' And [Salyear]='" & [me]![Label17].[Caption] & "'")
it gives #Name?
what is the problem and how can i change the label caption to Combo box column 2 value
pls give me solution
i want to result as dlookup function in access 2007
when i use dlookup like this
=DLookUp("GPFDed","[SalaryAll]","[EMPID]='" & ![Cmb_EMPID] & "' And [SalMonth]='" & "Jan" & "' And [Salyear]='" & [me]![Label17].[Caption] & "'")
it gives #Name?
what is the problem and how can i change the label caption to Combo box column 2 value
pls give me solution