![]() ![]() ![]() If you want spaces between the names then: Username: FirstName & Lastname & CustomerID In the first available empty column in the top row join the three fields by entering the following syntax: The questioner has three fields therefore to combine the three fields together then it would look like this: ![]() The requirement is Combining Firstname (the first letter), Lastname (the whole part of the lastname) and CustomerID (the whole ID) into 1 Field, Username.Įvery time I run the query that i have, Access does not like how i have the update set. You may have the occassion to do this on a Microsoft Access form, report or query. To concatenate is to join one or more fields together in Microsoft Access.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |