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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Headache on Outer Join with Crosstab 1
Page numbering with Merged Document and IF statements 1
Concatenation of blank and text fields 3
Select group number for distinct rows based on two columns 1
help with vlookup, offset or match formula's 0
Access SUMs Full Column When Using Subquery 2
Looping through data with calculations 1
Advanced Excel training in Chennai 0

Top