I have 3 columns in my table.

  
pidm            schol_code           paid_amt
000000          AMMPBB               35000
000001          AMRSST               25000
000002          DEPTLL               9000
000003          DOVERL               3500
000004          SLEEPS               4300
000005          SLIVER               3322
000006          MERITS               8000
000007          GRANTS               7088
000008          GRSSTP               9000

The report should sum each scholarship using the first letter (LIKE D%, LIKE G%, etc) and should look like this:

  
D%_Students    Amount
2              12,500

M%_Students    Amount 
1              8000          

I know how to do this for individual Scholarship types using WHERE schol_code LIKE 'D%', but this would require an individual report for each new letter (D%, M%, G%, etc). Is there a way to sum them all in the same report?

How about a Define that just pics the first letter from the schol_code...and then you sort by that?