Hi Everyone
I want to know what to do to have the full name
in fieldC using first name in fieldA and last name in fieldB
(as concatenate in excel)
Thanks
Hi Everyone
I want to know what to do to have the full name
in fieldC using first name in fieldA and last name in fieldB
(as concatenate in excel)
Thanks
You would use a calculated field in a query to concatenate the two fields.
FullName: [Firstname] & " " & [LastName]
You do *not* want it in the table.