2 groups-Help

C

catherine

Hi- I hope you can help. I have a query/report that I
need to group based on Lesson by Kit. Here's an example
of the way the data is entered.

Kit 07-006
Part LessonA LessonB LessonC
8476 2 5 7
6181 2 3
6475 5 6

So I would like a report to print by lesson and kit:
Kit 07-006
Lesson 2
Part: 8476
Part: 6181

Lesson 3
Part: 6181

Lesson 5
Part: 8476
Part: 6475

How should I achieve this result? Thanks for any tips!!
 
Top