Gustav Brock
Gustav at cactus.dk
Mon Nov 12 10:15:41 CST 2007
Hi John The "secret" function Partition (look up the on-line help) is what you are looking for. /gustav >>> jwcolby at colbyconsulting.com 12-11-2007 17:01 >>> 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