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
