I have no idea about month and year....coz i didnt understand what you actually want. But for the sum part it is like Select sum(qty) from <tablename> group by <fieldname>; print <tablename>.qty; pause;
From: hendAly unes <[EMAIL PROTECTED]> Subject: [development-axapta] How To Sum To: [email protected] Date: Sunday, August 17, 2008, 12:17 PM Dear All I want Help in sql statment in Axapta iwant to Select Statment For Excmple select Sum(Qty) As Qty,Month( Date)As Month , Year(Date)As Year From Table 1-How To Convert This Sql Statment To Sql Statment In Axapta 2- Any Books To Help Me In Just Sql Statments Thnaks Send instant messages to your online friends http://uk.messenger .yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
