Sum If function in textbox

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top