|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 2nd, 2010, 08:18 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Crosstab Groupings
I would like to create a crosstab query to count IDs by specific ranges:
95% 75 - 94% 50-74% 50% I do not know how to create this grouping by percentage. 
|
|
#2
March 2nd, 2010, 09:53 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Crosstab Groupings
Post the SQL of your crosstab.
-- Build a little, test a little. "Karen" wrote: I would like to create a crosstab query to count IDs by specific ranges: 95% 75 - 94% 50-74% 50% I do not know how to create this grouping by percentage.
|
|
#3
March 2nd, 2010, 10:47 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Crosstab Groupings
Also, do you want these groupings as Row Headings or Column Headings?
Can you share anything about your table(s)? The first thing I would do is to create a buckets table that identifies the minumum and maximum values for you range "buckets". tblBuckets =================== BuckMin BuckMax BuckTitle 0 49 Less Than 50 50 74 From 50 to 74 75 94 From 75 to 94 95 99999 95 and Greater -- Duane Hookom Microsoft Access MVP "KARL DEWEY" wrote: Post the SQL of your crosstab. -- Build a little, test a little. "Karen" wrote: I would like to create a crosstab query to count IDs by specific ranges: 95% 75 - 94% 50-74% 50% I do not know how to create this grouping by percentage.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
