Returns a string that joins substrings from an array.
Syntax
Join(sourcearray[, delimiter])
The Join function syntax has these arguments:
| Argument | Description |
|---|---|
sourcearray |
Required. A one-dimensional array that contains the substrings to join. |
delimiter |
Optional. A string character that separates the substrings in the returned string. If you omit it, Access uses a space character (" "). If delimiter is a zero-length string (""), Access combines all items in the list with no delimiters. |