kelsita_05
Registered User.
- Local time
- Today, 07:08
- Joined
- Aug 23, 2005
- Messages
- 52
I'm trying to put together some statistical reports using a crosstab query, and failing miserably.
Here is what I would like to do:
I have 5 fields (A, B, C, D, E) for ranking items. The available values are 0,1,2,3. What I want to do is show how many of each number was entered in a given time period. The user will enter the date range (have this set up and working).
It should look something like this:
0 1 2 3
A 4 6 10 8
B 5 7 0 6
C 2 10 11 8
I did a bunch with crosstab queries several years ago and had great success. I tried for hours to get it to work in this case, but I can't figure out how to set the column headings as the number values, and to deal with the multiple fields for row headings. I don't care if they are reversed (i.e. A, B, C on the top.
Any thoughts would be deeply appreciated.
Here is what I would like to do:
I have 5 fields (A, B, C, D, E) for ranking items. The available values are 0,1,2,3. What I want to do is show how many of each number was entered in a given time period. The user will enter the date range (have this set up and working).
It should look something like this:
0 1 2 3
A 4 6 10 8
B 5 7 0 6
C 2 10 11 8
I did a bunch with crosstab queries several years ago and had great success. I tried for hours to get it to work in this case, but I can't figure out how to set the column headings as the number values, and to deal with the multiple fields for row headings. I don't care if they are reversed (i.e. A, B, C on the top.
Any thoughts would be deeply appreciated.
