need help with confusing report.

[cdoyle]

Hi,

In my db, when the user is entering data they have 3 combo boxes that they make selections from.

So I've been asked to make a report that shows the total per user for each combinations of seletions from the combos.

For example:
a user can select from
combo 1 option 2
combo 2 option 1
combo 3 option 5

then the same user can make another selection that has the same selected options as the first record.
combo 1 option 1
combo 2 option 3
combo 3 option 1

Then if they made a 3 entry that had the same selections as the first record.

The report would show 2 rows, the first row would show the selections and a total of 2.
The second row would show the selections and a total of 1.

Is something like this possible? I'm not sure how to start on something like this. I wouldn't create a query for every possible combo right?

 

[cdoyle]

What they want to see is how many times each combo of selections were used per user.

So the report would look something like


user 1
combo 1 'option 2'.....combo 2 option 1....combo 3 option 5 Total 2
combo 1 'option 1'.....combo 2 option 3....combo 3 option 1 Total 1
next combo
next combo

User 2
do it all over again...