jwcolby
jwcolby at colbyconsulting.com
Mon Nov 12 10:01:12 CST 2007
I am doing a count like this 10 11 12 13 14 15 16 17 etc AK AL AR AZ This is by state, by boat length. However the user wants the boat lengths grouped, i.e. a single column for 10-15, 15-20 etc. where I have summed the counts for 10,11,12,13,14, and 15 and display that in a single column. Is this possible in a single query or am I going to have to go to a separate query to sum the lengths by state and then add that in to the crosstab somehow? John W. Colby Colby Consulting www.ColbyConsulting.com