Query Design Help

[ecugrad]

Need some advice on building a query..

I'm utilizing 2 tables: Region,AccountData

The region table contains 35 regions.I'm using Prin_Bal and SScore fields from AccountData. The AccountData table contains around 50,000 accounts each containing a prin_bal and SScore. I need to sum the prin_bal for each region utilizing a range of SScore. I'm using 6 ranges. 0-124,125-144,etc.. I want to try to get output similiar to the below.

0-124 125-144 etc..
Region1 $50,000 $66,000
Region2 $100,000 $75,000
Region3

Any help would be appreciated,

Thanks
FM

 

[Crowley16]

have you tried playing about with the pivot table options? I think this would be the easiest way...