Report to gather data from 4 tables

L

LisaB

Have 4 different tables, each of which contain a "Barcode" field. I want to
create a "master" barcode list that brings in the barcode (and 2 other
fields) from each of the 4 tables -- I've created 4 separate barcode reports
already (1 for each table), but now I want to combine all 4 into one "master"
listing. Any ideas?? Thank you!
 
B

Barry Gilbert

This sounds like a job for a Union query. Look in online help for details.

Barry
 
Top