MS Access - ConcatRelated() Function

Question

Is the ConcatRelated() function still available in Access 2013?  I have been trying to get it to work and so far no luck.

Thank you

Answer 1

ConcatRelated() was never available in Access. There are various version of functions that concatenate across several records. Allen Browne has one, Ken Sheridan has one and there are many others. But you need to be aware its a third party function, not built in.

Answer 2

I see no reason why Allen Browne's function should not work in Access 2013.  It's available at:

http://allenbrowne.com/func-concat.html

You'll also find an alternative GetList function, using the highly efficient GetString method of the ADO recordset object in Concat.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to  amend the form design accordingly.  

If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.

This little demo file illustrates the use of the function by means of a report, using Northwind data.

Answer 3

It does work so no issue there.  Perhaps you should tell us what message you are getting or what is not working so we can better help...