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]

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"8200rpm" <(E-Mail Removed)> wrote in message
news:B98FFBC5-13BB-4983-B59B-(E-Mail Removed)...
>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