Access and most databases use SQL. The query design view in Access is a convenience for users- a special interface to let users deal with a graphic - but it is creating SQL behind the scene.
ConcatRelated is a function. It takes input parameters, and outputs a value. I copied the function from Allen Browns site and included it in module1 in the database. Since the function returns a value, and that value is the concatenated Titles, it is just a function call for each record in the DogTbl. If there is no title, the value is NULL. And, yes I name the value from the ConcatRelated
function Concatenated_Title.
If you open the query window in SQL View and type in the SQL I gave, you can open the query design window and see the graphic.
Note that some queries can not be displayed in the graphic/design mode. They are only available in SQL view.
The ConcatRelated function
Code:
Public Function ConcatRelated(strField As String, _
strTable As String, _
Optional strWhere As String, _
Optional strOrderBy As String, _
Optional strSeparator = ", ") As Variant
indicates the default separator is a comma.
Normally, you could adjust the call to the function and use whatever separator you want. However, I tried a few times and got syntax error repeatedly. So, I went to the function definition and changed the line (orange) by removing the comma and substituting a space.
Code:
Public Function ConcatRelated(strField As String, _
strTable As String, _
Optional strWhere As String, _
Optional strOrderBy As String, _
Optional strSeparator = " ") As Variant
Dr Soper and Steve Bishop videos are very good. Also 599CD has some very good youtube material.
Once you're somewhat comfortable with the relational stuff from Dr. Soper, look for some videos featuring
Dr.Jennifer Widom --she's excellent, but very fast.
Happy to help.