Author Topic: Microsoft Access Function Library: Join()  (Read 4999 times)

bbasujon

  • Administrator
  • VIP Member
  • *****
  • Posts: 1826
  • I want to show my performance at any where
    • View Profile
    • Higher Education
Microsoft Access Function Library: Join()
« on: August 15, 2012, 05:18:20 PM »
Function: Join()

Purpose: The join() function takes an array of strings and an optional delimiter as arguments and returns a single string that contains each string from the input array, separated by the delimiter (if applicable).

Usage: IsError(array, [delimiter])

Returns: Concatenated string

Example:

Dim MyString() As String = {"Eat", "Pray", "Love"}
Dim ResultString As String = Join(MyString, ", ")

In this example, ResultString would contain "Eat, Pray, Love"
Acquire the knowledge and share the knowledge so that knowing,learning then sharing - all are the collection