Crosstab query with custom grouping

K

Karen

I would like to create a crosstab query to count by Id for specific
percentage grouping. The ranges are:
95% >
75 - 94%
50-74%
<50%

I am not sure how to create the groupings.
 
J

John Spencer

Hard to say, but maybe use this expression as the column value

SWITCH([SomeField]>=.95,'95+'
,[SomeField]>.74,'75-94'
,[SomeField]>=.5,'50-74'
,[Somefield]<.5,'<50'
,True,'No value')



John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab Groupings 2
Append Crosstab Query to Existing Table 0
Need some PWA help 0
How to Create an S-Curve from Custom Field? 0
crosstab query 2
crosstab 1
crosstab query child table count 5
crosstab query question. 3

Top