I work for a major servicer. Our service call data is stored in a data warehouse where a go-between pulls ad-hoc data for managers. The dataset contains the repair comments and parts installed. For each part listed, the comments are listed in duplicate.
"Fixed it" | "Part#1"
"Fixed it" | "Part#2"
etc...

I need to query the table to show the comments one time and then all parts following. Trying to pull from records and make new columns. Stuck doing that. Am I barking up the wrong tree? Any ideas on a fix?

Stumped in Tampa.

-david

This may be way off, but I'm not sure of your question.

Have you tried running a REPORT based off this recordset and GROUPING the data by the COMMENT field?

Thank you for your reply.

Yes, I did try the grouping. I left out a part however. There is a limit on the number of groups (4 I believe). My data tables are not quite as simple as my example. There are 10 fields that stay the same for each order and 4 fields that have the different data. Long story short, there is not enough grouping levels available to use the report grouping.

You were not off-base, you were actually right on. The data set is just more complex than my example.

A better example of what I have would be:

Customer Request/Service Comments/ServiceDate/Charge Field/Part #1/Service Code#1
Customer Request/Service Comments/ServiceDate/Charge Field/Part #2/Service Code#1
Customer Request/Service Comments/ServiceDate/Charge Field/Part #1/Service Code#2
Customer Request/Service Comments/ServiceDate/Charge Field/Part #2/Service Code#2

Again, thank you very much for your help. I should had spent more time expalining the full scope of my need.

My "cutting room floor" is completely covered.

-david

You can set up to 10 grouping levels in report view. Goto the design view of the report....right click on the upper left hand square and choose sorting and grouping levels.

Is 10 enough?

If not, you seem to have a need for more than one query/report.