select id_desc,sum_ap_total ; from sql_ap_pre ; where ap_status = .pcStatus ; group by id_desc, sum_ap_total ; into cursor sql_ap readwriteThe id_desc and totals are shown as:
AP-MISC 500.00 AP-OFFICESUPPLIES 500.00 AP-OFFICESUPPLIES 500.00 AP-OFFICESUPPLIES 2000.00 AP-COMPUTERS 5000.00 AP-COMPUTERS 3000.00 AP-COMPUTERS 7000.00 AP-COMPUTERS 1500.00 AP-OFFICESUPPLIES 50.00 AP-MISC 1000.00where as I am trying to accomplish:
AP-COMPUTERS 11500.00 AP-OFFICESUPPLIES 3050.00 AP-MISC 1500.00I even narrowed this code down thinking that it was because I have more fields originally, but even when I now have only two fields, it does not come out right. Does anyone please have a solution for this in VFP 8 aside from using the 7 Engine to calculate correctly??