create a recordset using the following SQL:
SELECT type, SUM(price) AS priceSum FROM products GROUP BY type
dont forget to add an alias SUM(price) AS priceSum
then use the bindings panel to echo the information to the page and a repeat region if the recordset returns more than one row.
because you are creating one recordset to return the results that you had been trying to get using multiple recordsets.
this:
SELECT
SUM(CASE WHEN Mbr_Status = 'Regular' THEN 1 ELSE 0 END) StatusRegular,
SUM(CASE WHEN Mbr_Status = 'App' THEN 1 ELSE 0 END) StatusApplicant,
SUM(CASE WHEN Mbr_Status = 'None' THEN 1 ELSE 0 END) StatusNone,
SUM(CASE WHEN Mbr_Status = 'Club' THEN 1 ELSE 0 END) StatusClub
FROM member_accounts
looks OK, except for the fact that the alias's are missing the ass statement.
If you need more help in createing this, i would sugest signing up for a premiere support appointment:
http://www.webassist.com/premier_request.php