[RBG7-L] - RE: Can Anyone see anything wrong

[Dawn Oakes]

Same way... sel drivname, count(pon) as cnt, sum(CDICosts) as sumcost from vbd_rep_data1 group by drivname   You can do min, max and average too! From: Steve Breen [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 5:37 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Can Anyone see anything wrong Thanks Dawn,   This is working but my next question is this what if I wanted a sum of (CDICosts) to go along with this. -----Original Message----- From: Dawn Oakes [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 5:27 PM To: [EMAIL PROTECTED] Subject: [RBG7-L] - RE: Can Anyone see anything wrong Try it this way: sel drivname, count(pon) as cnt from vbd_rep_data1 group by drivname From: Steve Breen [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 5:22 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Can Anyone see anything wrong I am trying to use this simple sel command to generate totals.   sel (drivname, cnt)as sel drivname, count (pon) from vbd_rep_data1 grouped by drivname   It is not working and I know I am over looking something simple but not sure what it is.?   Looking for advice     Stephen Breen CDI Services, Inc. 3610 Deahl Court P.O. Box 3838 South Bend, IN 46628 574-271-2027 Ext: 200 Fax 574-247-4638 Fax: 574-247-4631 Email: [EMAIL PROTECTED] Web Site www.911roadrepair.com Pager 800-668-8023 Cell 574-339-2356

<<Blank Bkgrd.gif>>