Report Format Question

[chad101]

I have a report which lists a summary of “customer parts”. Don’t ask me why but my boss is bugging the hell out of me to change the format of this report to display the spec high and low, Stdev, and Avg on only ONE horizontal line per part. As you can see if a part number has two or more inspections a separate line is needed to display the different inspection summary. I have enough room to print the report with a horizontal format. My problem is finding a way to change it. I tried a cross tab query, columns (across-down) in “page setup” and some VBA snippets I found on this site from other who have asked this question. Anyone have an idea?
Query

Report

 

[chad101]

I figured it out. I made two queries one with case inspections the other with only hardness inspections. Created two sub reports, one for each query, linked part ID as my child then placed them side by side. Cross tab would not work since I needed to reuse the data for different math functions.