count and if statement

[creeater]

I have a field called Section. In the field are three department
called Shipping, Processing, and Hold. So it would look like this:

Shipping
Shipping
Processing
Hold
Hold


I would like to put a count for each department on the last page...lik
this

Shipping: 2 Processing: 1 Hold: 2

I would think the count and if statement can work, but I can't figur
out the formula. thanks.*Section

 

[Evi]

You can do this in a Totals query. Drag the Section field twice into the
query grid, click the Totals button on the toolbar and in the Total row
choose Count under the second
Section.

You can then drag the Totals query into the report Footer, in report design
view where it will become a subreport.
Evi