>Can i get SELECT to produce the same results as TOTAL ON? I tried with GROUP BY but it did not sum up the values. What am I doing wrong?

In additon to GROUP BY you also have to use SUM() function for the fields you want to get total on.

SELECT keyfld, SUM(fld1), SUM(fld2), ...
  GROUP BY keyfld
...