Thanks in advance for any insight provided.

I need to create a report with 6 fields.

The first five fields are all BY fields. Namely, School_1, Grade, School_2, Service_1, and Service_2. The sixth is a DETAIL field and contains Student_Name.

Boring so far huh?

I have a requirement to provide a count of students who have common values in the BY fields. Similar in appearance to a sub-total.

I can't use a subtotal without a sum field, but I have nothing to sum.

Any ideas?

Thanks again.

This message has been edited. Last edited by: Kerry,

This is fairly simple actually. Create a defined field:

DUMMY_FLD/I5 = 1;

Now you have something to SUM. Since you probably do not want this to appear in your report, you can NOPRINT it and use the ST.DUMMY_FLD in a SUBFOOT.

or you can do a multiverb query