how to do the sum on the report?

[Mayo123]

I am using Access 2000.
I have a summary report which needs to show total counts of each category. On the report there’s a field called PG13Rated (text datatype, which has a value Y or N). I need the report to show how many Y (N) in each category. Is it possible to the do calculation on the report? If so, how? Could you please help me out? Thanks a lot!

 

[Remou]

How about:
=Sum(IIf(PG13Rated ="Y",1,0))

 

[Mayo123]

Thanks, Remou! It worked
I skipped o in order to leave it blank when its value is N