Multiple sources in ONE column... is it possible???

[8200rpm]

I would like to make a report with one of the columns reporting data from
more than one source. How do I make this work? Thanks for the help

 

[Allen Browne]

If you want to combine the values in a field from multiple tables into one
long list, use a UNION query. Example:
SELECT Field1 FROM Table1
UNION ALL
SELECT Field1 FROM Table2;

If you want to concatenate 2 fields together (such as a first name and
surname), use an expression in the Control Source of the text box like this:
=[firstname] & " " & [surname]