Hi
I want to make an expression to find out the value of a field particular employee of previous month, and i have put the following expression for it
prevdays:
Code:
DLookUp("[Plus_days_cf]","[ATTENDANCE]","[Emp_code]='" & [ATTENDANCE]![Emp_code] & "'" And "[Month_id]=" & (([ATTENDANCE]![Month_id])-1))
the criteria i have put give work individually but when i combine...