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)