Query to merge two fields into one

[GeorgeM]

Hello everyone. I am new on this forum so let me pop my first question. As per picture below, I need a query to result in merged two fields into one.



Thanks for your assistance.

[vazdajic]

Hi George.

You can go like this:

Full Name: [User Name] & " " & [User Last Name]

[ssanfu]

Also advise to NOT use spaces in object names (field, table, query, form or report names)
Use "CamelBack" or, if you must separate the words, use the underscore.

"User Last Name" would be "UserLastName" or "User_Last_Name"

[Micron]

This won't be an append or update query, I hope, because putting multiple data values in one table field isn't proper normalization.

Expect your db to rapidly swell in size if you have a lot of attachments in your tables (or fewer than a lot if they're large ones).