Count question

[rynorem]

Ok I"m a new to Access, so bare with me.

I have a report:

DATE TRANS ALR ASG_LOSS_DESC

20060508 DSCH SC SELECTIVE OR QUALITATIVE
20060508 DSCH SC SELECTIVE OR QUALITATIVE
20060508 DSCH SC SELECTIVE OR QUALITATIVE
20060508 DSCH SC SELECTIVE OR QUALITATIVE
20060508 DSCH SC SELECTIVE OR QUALITATIVE
20060519 SEP SE SEPARATION,ADMINISTRATIVE
20060512 DSCH SL SUBSTANDARD
20060508 DSCH TK TRAINEE DISCHARGE
20060531 DSCH TK TRAINEE DISCHARGE
20060515 DSCH WB DISCHARGED TO ACCEPT
20060516 SEP WB DISCHARGED TO ACCEPT
20060520 DSCH WB DISCHARGED TO ACCEPT
20060515 DSCH WB DISCHARGED TO ACCEPT

I want to count each group of ASG_LOSS_RSN. I've already grouped it by ASG_LOSS_RSN. If I use COUNT I get a criteria error message and if I use SUM in the footer it goes to the bottom of the page. I just want a number count after each group of ASG_LOSS_RSN. Thanks.

 

[Rich]

Use the GroupFooter for your calculated field

 

[rynorem]

THanks. It worked.