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?

 

[Uncle Gizmo]

I'm not following you, You say .....

>>>the first row would show the selections and a total of 2<<<

do you mean the first row would show all Records that have the following selections?
combo 1 option 1
combo 2 option 3
combo 3 option 1

 

[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...

 

[Uncle Gizmo]

I think I understand what you want, I'm still not absolutely sure.

I will assume that each combo box stores a number in a field depending on the selection made.

Therefore you will have a table similar to this:
f1-f2-f3
1--2--3
1--2--1
2--1--2
1--2--3
1--2--1
2--1--2

if that's the case then I would pull these values out into a query and have a calculated field in the query which concentrates the three values thus:

Calc Field:
123
121
212
123
121
212

You now have a list of values that lend themselves to grouping in another query, and you should be able to count the groupings.