Access count a field in access report

Status
Not open for further replies.
Joined
Oct 23, 2016
Messages
2
Reaction score
0
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
 
Joined
Oct 25, 2016
Messages
2
Reaction score
2
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"
 
Last edited:
Joined
Oct 23, 2016
Messages
2
Reaction score
0
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
 
Status
Not open for further replies.

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