G
Guest
In the Form Header for my subform, I am trying to add up the values based on
the value in another field in that sub form record.
Specifically, I am trying to Sum the number of days [NumDaysTaken] for an
Emp_ID, for all records that have "Vacation Day" in the LeaveType field.
LeaveType is a lookup so the value is a number.
=Sum([NumDaysTaken] ) where [Type] =1 And [EmpID] =
Forms![f_MainEmployeeData]![Emp_ID] )
I am getting an Invalid syntax error --- I have tried all combos of brackets
but am missing something.
thanks
sandy
the value in another field in that sub form record.
Specifically, I am trying to Sum the number of days [NumDaysTaken] for an
Emp_ID, for all records that have "Vacation Day" in the LeaveType field.
LeaveType is a lookup so the value is a number.
=Sum([NumDaysTaken] ) where [Type] =1 And [EmpID] =
Forms![f_MainEmployeeData]![Emp_ID] )
I am getting an Invalid syntax error --- I have tried all combos of brackets
but am missing something.
thanks
sandy