First page Back Continue Last page Image

Merging Text from 2 Fields into a Single Result

Let’s say my Query will be used to make Labels, So basically my output will be the list of Fields I want on the Label

For this example we will use the CONCAT Function on our ships table in the StarPeople Database

While our results did do the Concatenation, it is not in a format we can use, we need a space between the 2 text strings

CONCAT(First Text String, Next Text String)