Chester Friesen wrote: > I have an app in VFP7 that I need to sort on group totals. Is that a job > for VFP9? Forget it for VFP7? > Now, the report looks nice, but needs the totals sorted on each group. I > have tried a 2 pass routine, but it's not really working right. I don't > know if this is enough info to give me some ideas or not. >
I must not be understanding the problem. This works fine for me in vfp7: SELECT stylename, sum(units) as sumall FROM gmoodet GROUP BY stylename ORDER BY sumall Or, sometimes when I do have problems sorting on a column becuase "no such column", I can use positional sorting: SELECT stylename, sum(units) as sumall FROM gmoodet GROUP BY stylename ORDER BY 2 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
