Count formula in Reports

Y

yellowclocker

I want to count in a report how many times it says Roberts in my surname
field because there are quite a few children with that surname. I thought it
would be something like
=Count(([Surname])=Roberts) but it doesn't work.... can anyone help me?
Thanks
 
M

Marshall Barton

yellowclocker said:
I want to count in a report how many times it says Roberts in my surname
field because there are quite a few children with that surname. I thought it
would be something like
=Count(([Surname])=Roberts) but it doesn't work.... can anyone help me?
Click to expand...


=Abs(Sum(Surname="Roberts"))
 
Top