Access count a field in access report

[sajjad]

i have an report in access and i want to count a field with specify value my filed name is "id wbs" and my value is "construction"

please answer me

i used =Sum(IIf([ID WBS]='construction',1,0))
but it isnt correct
please help

 

[Joshi]

Hello. Did you get a syntax error? If yes, try to replace comma by semicolon in the expression:

=Sum(IIf([ID WBS]='construction';1;0))

If you see '#error' text in the field instead of actual value, please make sure that you specifyed "Control Source" for the report properly. For example, it could be "SELECT * FROM your_table_name"

 

[sajjad]

T

Hello. Did you get a syntax error? If yes, try to replace comma be semicolon in the expression:

=Sum(IIf([ID WBS]='construction';1;0))

If you see '#error' text in the field instead of actual value, please make sure that you specifyed "Control Source" for the report properly. For example, it could be "SELECT * FROM your_table_name"

Thanks a lot
It worked