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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 
Back
Top