Create Cursor Sql_Ap_Pre (Id_Desc C(20), Sum_Ap_Total Y) >>Insert Into Sql_Ap_Pre Values("AP-MISC", 500.00) >>Insert Into Sql_Ap_Pre Values("AP-OFFICESUPPLIES", 500.00) >>Insert Into Sql_Ap_Pre Values("AP-OFFICESUPPLIES", 500.00) >>Insert Into Sql_Ap_Pre Values("AP-OFFICESUPPLIES", 2000.00) >>Insert Into Sql_Ap_Pre Values("AP-COMPUTERS", 5000.00) >>Insert Into Sql_Ap_Pre Values("AP-COMPUTERS", 3000.00) >>Insert Into Sql_Ap_Pre Values("AP-COMPUTERS", 7000.00) >>Insert Into Sql_Ap_Pre Values("AP-COMPUTERS", 1500.00) >>Insert Into Sql_Ap_Pre Values("AP-OFFICESUPPLIES", 50.00) >>Insert Into Sql_Ap_Pre Values("AP-MISC", 1000.00) >> >>Select Id_Desc, Sum(Sum_Ap_Total) AS Totals ; >> From Sql_Ap_Pre ; >> Where .T. ; >> Group By Id_Desc>