Thanks for all the replies
I ended up using strongm's approach as it worked when there was only one record. Duanes process worked but if there was only one name it put the & in from of it e.g &Jill
Thanks again
Hi I have been using Duanes code to concatenate names from at the same address e.g Jack,James, Jill
I would like to do Jack, James & Jill
Any Ideas on how to add the & before the last record?
Cheers
Ben
Function Concatenate(pstrSQL As String, _
Optional pstrDelim As String =...
This is direct toward Duane Hookam developer of the At Your Survey template database but would appreciate any other contributions
First I would like to thank Duane for his contribution to the world of Databases. I work for an non profit organisation that runs many different workshops, training...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.