AVPUSA DATABASE

Workshops by State   Export to Excel  Export to Word
	Page   of 5      Records 1 to 3 of 14      Groups per page  1 2 3 4 5 10 20 50 All Year Chapter State Prison Commun Special Adult Youth Basic Adv T4F Mini Partic Hours 1999 Summary for Chapter State: NV (1 detail records)   SUM 1 0 0 1 0 1 0 0 0 16 22 Summary for Year: 1999 (1 detail records) SUM 1 0 0 1 0 1 0 0 0 16 22 2000 Summary for Chapter State: NE (1 detail records)   SUM 9 0 0 9 0 6 2 1 0 146 159   Summary for Chapter State: NY (1 detail records)   SUM 3 0 0 3 0 0 3 0 0 21 66 Summary for Year: 2000 (2 detail records) SUM 12 0 0 12 0 6 5 1 0 167 225 2001 Summary for Chapter State: FL (1 detail records)   SUM 0 27 0 27 0 14 4 1 8 274 368   Summary for Chapter State: KY (1 detail records)   SUM 0 1 0 0 1 1 0 0 0 14 22   Summary for Chapter State: LA (1 detail records)   SUM 9 1 0 10 0 7 2 1 0 99 220   Summary for Chapter State: MA (1 detail records)   SUM 8 0 0 8 0 5 1 0 2 148 144   Summary for Chapter State: MD (1 detail records)   SUM 12 0 0 12 0 8 4 0 0 240 252   Summary for Chapter State: ME (1 detail records)   SUM 2 0 0 2 0 1 1 0 0 11 44   Summary for Chapter State: NE (1 detail records)   SUM 9 0 0 9 0 5 3 1 0 132 162   Summary for Chapter State: NY (1 detail records)   SUM 183 9 1 192 1 118 49 17 9 2745 4140   Summary for Chapter State: WY (1 detail records)   SUM 1 0 0 1 0 1 0 0 0 12 18 Summary for Year: 2001 (9 detail records) SUM 224 38 1 261 2 160 64 20 19 3675 5370

(Popup SQL): SELECT DISTINCT [Year] FROM [workshops by state] ORDER BY [Year]
(Popup SQL): SELECT DISTINCT [State] FROM [workshops by state] ORDER BY [State]
(Group SQL): SELECT DISTINCT [Year] FROM [workshops by state] ORDER BY [Year] ASC
(Detail SQL): SELECT [Year], [State], [Prison], [Commun], [Special], [Adult], [Youth], [Basic], [Adv], [T4F], [Mini], [Partic], [Hours] FROM [workshops by state] WHERE ([Year] = 1999) ORDER BY [Year] ASC, [State] ASC
(Detail SQL): SELECT [Year], [State], [Prison], [Commun], [Special], [Adult], [Youth], [Basic], [Adv], [T4F], [Mini], [Partic], [Hours] FROM [workshops by state] WHERE ([Year] = 2000) ORDER BY [Year] ASC, [State] ASC
(Detail SQL): SELECT [Year], [State], [Prison], [Commun], [Special], [Adult], [Youth], [Basic], [Adv], [T4F], [Mini], [Partic], [Hours] FROM [workshops by state] WHERE ([Year] = 2001) ORDER BY [Year] ASC, [State] ASC