Hi Cathy - thank you so much for your patience!
>
>I'm still unclear on one thing ... Is each different "service" a different record in the table, or do you have several different service fields in the record? IOW, are you totally the number of records to find the number of services or are you checking several fields and counting how many are not zero?
>

A single record may have up to 7 services e.g., feecode1, feecode2, feecode3.....feecode7. The report looks like this:

Id Number Client Name Service Date Fee Code Premium Code Amount
123456 Doe, John 12/12/2001 123A A 248.65
124A 105.00
225G 85.99
234567 Mathers, Joe 12/13/2001 425X 1 366.00
_____________________________
Number of Clients: numbill (counts OK)
Number of Services: numofservs (PROBLEM)
Total amount for MR.T: docamt (works OK)

Note that if there are more than 1 services provided to a client, only the fee code and amount are printed, i.e., the client's name is not printed again. What I now need is to be able to:
a. Count the number of services rendered by Mr.T (in this example it would be 4 services - and this is what I hope variable numofservs to provide me) . This should also reset each time a new professional group is encountered, e.g. Miss X.
b. Grand out of all services for the office i.e., there may be a Miss.X and a Mr. Y also in the office providing services - therefore a grand total would be nice to have also.

Hope I a a bit more clear now. Thanks Cathy.

- Ravi