Hi, I have 2 columns, namely LastName and FirstName. Is there a way such that when the data is shown, the values of the two column appear in a single string by separated by a comma? Like Rodriguez, Sam
Hi, I have 2 columns, namely LastName and FirstName. Is there a way such that when the data is shown, the values of the two column appear in a single string by separated by a comma? Like Rodriguez, Sam
Sure.
In your query, go to a blank column and enter
FullName: [LastName] & ", " & [FirstName]
In SQL view it would look like
SELECT [LastName] & ", " & [FirstName] as FullName, {more fields} FROM TableName
In the Control Source of a text box on a form you could use (if the form record source had the two fields):
= [LastName] & ", " & [FirstName]
I perfer the first option....