Crosstab Help?..

[dezeptus]

Hello,

I have a table with the following info:
ID, CSR, Option 1, Option 2, Option 3, all the way to option 12.In the Option fields, you can enter a number from 1 - 12. What I'm looking for is a summary report that will give the number of times each number appears for each field. Something like this:

Option 1: 1 = 20 times, 2 = 5 times, 3 = 15 times
Option 2: 2 = 5 times, 2 = 10 times, 3 = 0 times

So on and so on. Would this be done with a crosstab query, or am I way off?

Thanks in advance for your help.


Alex

 

[dezeptus]

Thanks for the quick response!

So since I already have a table with all this information, is there a way I can go about seperating into multiple tables to accomplish this?

 

[mlai08]

Crosstab query - concatenate values

I have a question on Crosstab query and hope someone on the forum can help me to resolve the problem. I can not create a new thread on this topic.

I want to create a cross training matrix with crosstab query in Access to show the relationship between the trainers and trainees with purpose of the trainings from the following table.

XTrainID...Purpose.............Trainer.............Trainee
1.............Web Focus......... John................Edward
2.............Search Engine.....Mary................John
3.............CEI................... Matthew...........Edward
4............SAS................... Paul..................Mary
5.............NET.................. Greg.................Sam
6............SAS................... Jennifer..............Mary
7............SAS................... Matthew.............Edward

The resulting matrix should look something like this:

............ Greg...... Jennifer....John.............Mary........Matthew......Paul
Edward..............................Web Focus...................CEI, SAS
John.....................................................Search Engine
Mary...................SAS............................................................SAS
Sam....... .NET

I tried to use crosstab Q and picked Trainee as Row Heading, Trainer as Column Heading and Purpose as Value - with the Total option as First, but it would only show the first purpose even if trainer with the same trianee has more than 1 cross training involvement. The example is for Matthew & Edward. In this case, it only show CEI but not SAS. My challenge here is how to concatenate training purposes under the same trainer and trainee.

Thank you in adavnce for your help. Have a merry Christmas and happy New Year.

Mike