Posted January 3, 201311 yr FPCH Admin I have something I want to pitch out to the Microsoft Access development team. I know they read these forums regularly. A lot of users on other forums have been asking about an Access aggregate function that operates like the GROUP_CONCAT function first developed for MySQL and now supported by HSQLDB as well. The truth about GROUP_CONCAT is that it works EXACTLY the same way as the hidden macro that is deployed to concatenate the values of a multivalued lookup field. Please bear in mind that most users avoid multivalued lookup fields because it is sound database principle and would better work in situations where the database would need to be migrated to an SQL server. View this thread Off Topic Forum - Unlike the Rest
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.