thanks for your reply. much appreciated!

thanks guys. ive figured it out.

SELECT LEFT(all6,3) AS curr, COUNT(*) AS volume, SUM(MID (all6, 4, 20)) AS figure

FROM all6

GROUP BY LEFT(all6,3);

gives me the total volumes and balances of each...