Totalling a section in a report

[aneats]

i have a report with 'AdvSectionID' header and 'AdvSectionID' footer.
in the detail section there's a field called 'NetDays' (the amount of days it takes a Section to do something).
in the report footer i have 4 fields: Total cases cleared in 10 days
Total cases cleared in 15 days
Total cases cleared in 20 days
Total cases cleared in More than 20 days

These fields are calculated thus (Advice Cases test is the name of the query the report is based on):
=DCount("[NetDays] ","Advice Cases test"," [NetDays]<=10 ")
=DCount("[NetDays] ","Advice Cases test"," [NetDays]<=15 ")
and so on.

my problem is that i need to get the same totals in the AdvSectionID footer (need to know these results per section AS WELL as overall).

Can someone help.
Thanks

 

[Rich]

=Sum(Iif([NetDays]<=10,1,0) etc, and scrap the DCounts, you don't need them

 

[aneats]

Thanks very much. how straightforward was that?!
how stupid am i?!