Count

[a]

Why This code Not Work:

=Count("[job]='football_Player'")

 

[boblarson]

Count does not take any expression like you are using. You can, however use
something like this:

=Count(IIf([job]="football_Player",1,0))
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[boblarson]

Actually, I goofed slightly. Instead of Count, use SUM:

=SUM(IIf([job]="football_Player",1,0))
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Dale Fye]

depending on where you are trying to use this, you might also want to try:

=DCOUNT("SomeField", "tablename", "[job] = 'football_Player'")

If you are doing this in a query, or in a control in the header or footer of
a continuous form, I think Bob's answer is what you are looking for. If you
are doing this in a query, or in an unbound text box on a form, I think you
will want to use the DCOUNT( ) function.

HTH
Dale