MS Access 2007..
I have specification sheets for our products.



Spec Table contains the QA specifications. Correct order in report is controlled using a Position Order Field

I want to add 2 tables so other departments can enter their data as the make tweeks. Maintenance Department Table and Engineering Department Table. The KEY is Product ID field.

I can set up the Department Tables to include the Position Order Fields so they only have to enter Minimum Value, Target Value, Maximum Value

I want to use all 3 Dept data to make a combined spec sheet report.

After trying to run a test query I have the 3 Departments data on the same line of the query output.
EXAMPLE OF OUTPUT OF QUERY EXECUTION: Product ID, QA Data, Maintenance Data, Engineering Data.

How do I set up the query or report to give me a report simiar to:

(Vertical orientation)

PRODUCT ID
(w/ Position Order Fields)
QA Data
Maintenance Data
Engineering Data

Other suggestions greatly appreciated!