Utilisation d'expression =compte() avec condition

[nyandry]

I created a list ETAT in access, I want to put the recap of boy and girl in the footer of each group.


Now I use =compte(*), the result is the all number of boys and girls

[Welshgasman]

You need criteria to determine whether boy or girl?
So perhaps create a hidden field that is set to 1 if boy. Then subtract that total to get the girls from your current total, or use two fields to calc boy or girl.
Or perhaps if Boy then 1, else -1 and then use ABS() for the girls?

That would not work in this country, you would need about 5 fields for all the variations.

Checkout the IIF() function.