- Joined
- Apr 13, 2012
- Messages
- 8
- Reaction score
- 0
I have a form called "Headcount" with the fields "EmployeeType" and "Count"
How do I write an equation in a textbox at the type of the form that sums the "Count" field when the "EmplyeeType" = Salary?
I've tried putting =Sum(IIf([EmployeeType]="Salary",[Count],0)) but I get #Error
Thanks!
How do I write an equation in a textbox at the type of the form that sums the "Count" field when the "EmplyeeType" = Salary?
I've tried putting =Sum(IIf([EmployeeType]="Salary",[Count],0)) but I get #Error
Thanks!