You can find this in the developpers guide .. but here goes ... select sum(field) from table group by some_field_in_table
--- In [EMAIL PROTECTED], "axapta_dude" <[EMAIL PROTECTED]> wrote: > hello guys.. > I hope u all can give me some guidance/pointer.What is the syntax for group by sum.I > hope u all can help me. > Thanx in advanced ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/