I have been using the ConcatRelated function (allenbrowne.com/func-concat.html)and while it works fine when the data comes from a table, but it doesn't work when the data comes from a query.
The green 'running query' bar appears for a few seconds, but then when it tries to display the data it shows only one field from the first row, runs very slowly and can take a few minutes to display the first screen of records. I've not managed to leave it long enough to complete the result set, have to shut down Access using the task manager.
Is the query getting run each time the function is called? That could explain why it takes so long but seems unlikely.
Is this a problem with the function, with the query that is calling the function, or the query that the source data is coming from?
The green 'running query' bar appears for a few seconds, but then when it tries to display the data it shows only one field from the first row, runs very slowly and can take a few minutes to display the first screen of records. I've not managed to leave it long enough to complete the result set, have to shut down Access using the task manager.
Is the query getting run each time the function is called? That could explain why it takes so long but seems unlikely.
Is this a problem with the function, with the query that is calling the function, or the query that the source data is coming from?