Count formula in Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"))
 
Back
Top