I have 3 Departments that need to maintain their own data for a report I generate.



I will create each dept a table in their own database to so I can link to their table data via a KEY: PRODUCT ID

My origional report has 1 table for the actual specs. I request your help in devising a query -> report for 3 additional tables for min, target, max data to combine in 1 report.

Right now my test query output is in the form of (on the same line)

PRODUCT ID / Dept 1, Spec Parameter 1, Min 1, Target 1, Max 1, Dept 2, Spec Parameter 2, Min 2, Target 2, Max 2, Dept 3, Spec Parameter 3, Min 3, Target 3, Max 3,....

I have a field named: ORDER to get spec parameter in perferred place on the report.

I would like report output to look something like:
PRODUCT ID
Dept 1, Spec Parameter 1, Min 1, Target 1, Max 1,
" "
" "
Dept 2, Spec Parameter 2, Min 2, Target 2, Max 2
" "
" "
Dept 3, Spec Parameter 3, Min 3, Target 3, Max 3,....
" "
" "

Query Problem?
Report Group / Sort Problem?

I trigger the print sequence when I scan a barcode.

Thanks for your time and suggestions.