Concatenate Issue

[Jennifer B via AccessMonster.com]

Hi All 0

I searched the posts for an answer to my concatenate question and found a
wonderful post, but I'm having a problem. I found the following link to a
module that can be used to concatenate a list of sub-record values. I tested
this in the northwind Db like I was told (97 version) and it worked fine. So
I tried it in my own Db which is 2000 and it does not work. =( So to see if
it could possibly be a version issue, I imported the exact same tables and
queries from the Northwind into my 2000 db and it does not run correctly. Is
there something in the module that needs to be formatted differently to work
with 2000? Please help! =)

Thanks!

Module can be found at: http://www.mvps.org/access/modules/mdl0004.htm

 

[Duane Hookom]

This is most likely a references issue since Access 2000 and later default
to using ADO while I believe the function from the Access Web uses DAO.
Check Allen Browne's site http://allenbrowne.com/ser-38.html for more
information.