Try this inventTrans.Qty
Axapta executes select statement in a little bit different manner than SQL. -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of setiaji kurniawan Sent: Wednesday, July 13, 2005 2:30 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Select statement Guys,anyone can help me? select sum(Qty) from InventTrans where InventTrans.DatePhysical < _startDate ; where can i get the value from the line above ? Refer to the Help Documentation, the value is in the field Qty in InventTrans tabel.But i cant get it. Is there any clue i can use to get the value from the line above? -- Best regards, setiaji mailto:[EMAIL PROTECTED] Sharing the knowledge on Axapta. Yahoo! Groups Links 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/