SELECT AccountNo, SUM(Total) AS Totals ;
  FROM mytable ;
  GROUP BY AccountNo ;
  ORDER BY AccountNo ;
  INTO CURSOR crsTotals

If you want to get only accounts with Totals > 1000.00

SELECT AccountNo, SUM(Total) AS Totals ;
  FROM mytable ;
  GROUP BY AccountNo ;
  HAVING Totals > 1000.00 ;
  ORDER BY AccountNo ;
  INTO CURSOR crsTotals

>i have a HUGE table with account numbers. I am trying to find a certain sum, but I do not know which account no it is linked to. I need to sum totals in batches. Can anyone help? For example:
>
>Account No Total
>111222
>111222
>111222
>123668
>123668
>123668
>123668
>569999
>569999
>569999
>569999
>569999
>569999
>
>I need to get the total of 111222 then 123668, etc... I have over 100000 records to go through. Can anyone help me?? THanks!!