Count field if "M"

[Peter.in.th]

As a complete FM beginner I have already become stuck.

I have a layout that gives me a list of a school house. I want to count the number of boys (M) and the number of girls (F) and the total number of students in that 'Found' group. I can't find a way to do that. 'Sex' is a field that is included and populated. I hope that all makes sense?

Please help

Peter.in.th

[aaa]

Hi, Peter.

Read about sumsamary part of layouts.

You can create report where you can see

F 500

M 200

Total 700.

This is only one of ways to do it. There is many ways to do.

[Peter.in.th]

Thanks aaa, but I tried to add a summary field to an existing layout but can't.

If using a summary field is the way to go that's fine, I'll try that.

[Genx]

Have a look at this Post.

~Genx

[Peter.in.th]

Many many thanks

I looked at the post as suggested Genx and it works perfectly. I would never have done that on my own.

I can see I have a lot to learn and will be a frequent visitor to this forum.