Paul - Can you do your summarization on the database side?
Something like: SELECT LEFT(ORG, 2) AS ORGTYPE, COUNT(GP3 PC) AS GP3_PC, COUNT(GP1 MAC) AS GP1_MAC, ... GROUP BY ORGTYPE I can't think of an "easy way" in Tango - I think you'd have to loop through your resultset, calculating sums and saving them to an array. jamileh > -----Original Message----- > From: Storey, Paul [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 18, 2003 9:41 AM > To: '[EMAIL PROTECTED]' > Subject: Witango-Talk: Summary Question > > > I'm looking for an easy way to take the results from a query > and summarize the results based on the first two digits of > the org field into a table. I have 16 different orgs and 13 > different seat types. Some orgs will not have a qty for some > seat types. Below is a sample table and resultset. Any > ideas would be appreciated. Thanks!!!!!!!!! > > > GP1 MAC GP3 MAC SE1 MAC GP3 PC SE1 PC SE2 PC SE1 > UNIX SE2 > UNIX SE3 UNIX NAD Total > AD 1 3 4 6 > 6 4 > 234 258 > CD 4 45 4 > 5 > 5 63 > DA 2 5 5 > 12 > DD 4 > 4 > 6 14 > DE 3 2 2 33 4 4 > 48 > FD 6 6 5 4 > 3 > 1 25 > Total 12 6 61 33 13 9 14 > 10 16 > 246 420 > > > Org Seat Type Qty > AD01 GP3 PC 1 > AD01 SE1 PC 12 > AD04 GP3 MAC 1 > AD04 GP3 PC 72 > AD04 NAD 16 > AD04 SE1 MAC 2 > AD04 SE1 PC 99 > AD04 SE2 PC 22 > AD10 GP3 PC 1 > AD10 SE1 PC 12 > AD10 SE2 PC 1 > AD20 GP3 PC 4 > AD20 NAD 24 > AD20 SE1 PC 131 > AD20 SE2 PC 3 > AD21 SE1 PC 8 > AD21 SE2 PC 1 > AD22 NAD 1 > AD22 SE1 PC 28 > AD22 SE2 PC 2 > AD23 NAD 6 > AD23 SE1 MAC 1 > AD23 SE1 PC 26 > AD30 GP3 MAC 4 > AD30 GP3 PC 17 > AD30 NAD 15 > AD30 SE1 MAC 8 > AD30 SE1 PC 115 > AD31 GP3 PC 10 > AD31 NAD 1 > AD31 SE1 PC 40 > AD31 SE2 PC 4 > AD32 GP1 MAC 2 > AD32 GP3 MAC 10 > AD32 GP3 PC 34 > AD32 NAD 2 > AD32 SE1 MAC 51 > AD32 SE1 PC 200 > AD32 SE1 UNIX 1 > AD32 SE2 PC 2 > AD33 GP3 MAC 1 > AD33 GP3 PC 64 > AD33 MA1 PC 1 > AD33 NAD 2 > AD33 SE1 MAC 13 > AD33 SE1 PC 244 > AD33 SE2 PC 9 > AD33 SE2 UNIX 1 > AD34 GP3 MAC 2 > AD34 GP3 PC 3 > AD34 SE1 MAC 2 > AD34 SE1 PC 8 > AD40 GP3 PC 4 > AD40 SE1 PC 7 > AD41 GP3 PC 1 > AD41 SE1 PC 52 > AD42 SE1 PC 49 > AD42 SE2 PC 2 > AD50 GP3 PC 17 > AD50 SE1 PC 59 > AD60 GP3 PC 1 > AD60 SE1 MAC 1 > AD60 SE1 PC 43 > AD60 SE2 PC 1 > AD62 SE1 PC 3 > CD01 GP3 MAC 1 > CD01 GP3 PC 4 > CD01 SE1 PC 17 > CD02 GP3 MAC 1 > CD02 GP3 PC 6 > CD02 SE1 MAC 1 > CD02 SE1 PC 14 > CD03 GP3 PC 2 > CD03 SE1 PC 5 > CD10 GP1 MAC 2 > CD10 GP3 PC 1 > CD10 SE1 MAC 4 > CD10 SE1 PC 42 > CD20 GP1 MAC 1 > CD20 GP3 PC 14 > CD20 SE1 PC 166 > CD20 SE2 PC 5 > CD30 GP3 MAC 1 > CD30 GP3 PC 8 > CD30 SE1 MAC 3 > CD30 SE1 PC 19 > CD30 SE2 PC 1 > CD40 SE1 MAC 2 > CD40 SE1 PC 10 > CD40 SE2 PC 1 > CD50 GP3 PC 2 > CD50 SE1 PC 7 > CD60 GP3 PC 2 > CD60 SE1 PC 20 > CD70 GP3 MAC 3 > CD70 GP3 PC 2 > CD70 NAD 1 > CD70 SE1 MAC 8 > CD70 SE1 PC 25 > CD70 SE2 PC 1 > DA01 GP3 PC 7 > DA01 SE1 PC 10 > DD01 GP3 PC 4 > DD01 SE1 PC 1 > DE01 GP3 PC 2 > DE01 SE1 PC 6 > ED01 GP3 MAC 1 > ED01 GP3 PC 1 > ED01 SE1 MAC 1 > ED01 SE1 PC 7 > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
