AVPUSA DATABASE

Workshops by Site/Age Level   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 Workshops (SUM)  Number of Workshops Year Chapter State Site & Age Advanced Basic Mini T4F Total 1999 NV Prison -Adult 0 1 0 0 1   Summary for Chapter State: NV 0 1 0 0 1 Summary for Year: 1999 0 1 0 0 1 2000 NE Prison -Adult 2 6 0 1 9   Summary for Chapter State: NE 2 6 0 1 9   NY Prison -Adult 3 0 0 0 3   Summary for Chapter State: NY 3 0 0 0 3 Summary for Year: 2000 5 6 0 1 12 2001 FL Community-Adult 4 14 8 1 27   Summary for Chapter State: FL 4 14 8 1 27   KY Community-Youth 0 1 0 0 1   Summary for Chapter State: KY 0 1 0 0 1   LA Community-Adult 0 1 0 0 1     Prison -Adult 2 6 0 1 9   Summary for Chapter State: LA 2 7 0 1 10   MA Prison -Adult 1 5 2 0 8   Summary for Chapter State: MA 1 5 2 0 8   MD Prison -Adult 4 8 0 0 12   Summary for Chapter State: MD 4 8 0 0 12   ME Prison -Adult 1 1 0 0 2   Summary for Chapter State: ME 1 1 0 0 2   NE Prison -Adult 3 5 0 1 9   Summary for Chapter State: NE 3 5 0 1 9   NY Community-Adult 1 7 1 0 9     Prison -Adult 48 110 8 17 183     Special -Youth 0 1 0 0 1   Summary for Chapter State: NY 49 118 9 17 193   WY Prison -Adult 0 1 0 0 1   Summary for Chapter State: WY 0 1 0 0 1 Summary for Year: 2001 64 160 19 20 263

(Popup SQL): SELECT DISTINCT [Year] FROM [Workshops by site-age] GROUP BY [Year], [State], [Site-Age] ORDER BY [Year]
(Popup SQL): SELECT DISTINCT [State] FROM [Workshops by site-age] GROUP BY [Year], [State], [Site-Age] ORDER BY [State]
(Column SQL): SELECT DISTINCT [Level] FROM [Workshops by site-age] ORDER BY [Level] ASC
(Group SQL): SELECT DISTINCT [Year] FROM [Workshops by site-age] GROUP BY [Year], [State], [Site-Age] ORDER BY [Year] ASC
(Detail SQL): SELECT [Year], [State], [Site-Age], SUM([Workshops]*IIf([Level]='Advanced',1,0)) AS [c1], SUM([Workshops]*IIf([Level]='Basic',1,0)) AS [c2], SUM([Workshops]*IIf([Level]='Mini',1,0)) AS [c3], SUM([Workshops]*IIf([Level]='T4F',1,0)) AS [c4] FROM [Workshops by site-age] WHERE ([Year] = 1999) GROUP BY [Year], [State], [Site-Age] ORDER BY [Year] ASC, [State] ASC, [Site-Age] ASC
(Detail SQL): SELECT [Year], [State], [Site-Age], SUM([Workshops]*IIf([Level]='Advanced',1,0)) AS [c1], SUM([Workshops]*IIf([Level]='Basic',1,0)) AS [c2], SUM([Workshops]*IIf([Level]='Mini',1,0)) AS [c3], SUM([Workshops]*IIf([Level]='T4F',1,0)) AS [c4] FROM [Workshops by site-age] WHERE ([Year] = 2000) GROUP BY [Year], [State], [Site-Age] ORDER BY [Year] ASC, [State] ASC, [Site-Age] ASC
(Detail SQL): SELECT [Year], [State], [Site-Age], SUM([Workshops]*IIf([Level]='Advanced',1,0)) AS [c1], SUM([Workshops]*IIf([Level]='Basic',1,0)) AS [c2], SUM([Workshops]*IIf([Level]='Mini',1,0)) AS [c3], SUM([Workshops]*IIf([Level]='T4F',1,0)) AS [c4] FROM [Workshops by site-age] WHERE ([Year] = 2001) GROUP BY [Year], [State], [Site-Age] ORDER BY [Year] ASC, [State] ASC, [Site-Age] ASC