Need to merge two columns into a report

[soklear]

Hi. I have a report column that requires two merged columns from the same table. How would I accomplish this?
When I try a union query and place it as the control source of the column in the report, it doesnt work.

Thanks,

Bob

 

[Trevil]

A simple example, assuming your table has fields named "FirstName" and "LastName", you could either have the query use:
SELECT [firstname] & " " & [lastname] AS FullName
FROM Contacts;

or
SELECT [lastname] & ", " & [firstname] AS FullName
FROM Contacts;


Learn from the mistakes of others. You won't live long enough to make all of them yourself.