SUMIF problem

[qwertyjjj]

Not sure what is wrong here.
I am trying to do a SUMIF expression to fill a textbox on a form based uon what is in onw of the other bound textboxes.

The expression is:
=SUMIF(TableName!FieldName,[Expr1001],TableName!FieldName)

Shouldn't this sum up the field values from the table when the first field name = [Expr1001]?

I just get a #Name? when I run the form.

 

[traingamer]

SUMIF is not an Access / VBA function.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[qwertyjjj]

Do you know of an alternative that can be used to do the same thing?

 

[qwertyjjj]

It's either that or link the textbox to a SQL query but the WHERE condition needs to change for each textbox

 

[rjoubert]

Check out the IIF function.