Concatenate Records

[Siiig]

Reference: https://www.accessforums.net/queries...-if-32325.html

Why would you want to denormalize data?

I'm actually looking to do something similar here.

I have similar data (I only need one field combined), I'll try and explain why I need them broken out...

Item Product
1-A 1
1-B 1
1-C 1
2-A 2
2-B 2
3-A 3
3-C 3


Above is a decent mimic of what I'm pulling from.

The preferable resulting data (at least, before a few more formulas) would be similar to this..

1 1-A 1-B 1-C

In finality I would like to get to...

1 A,B,C

A/B/C equate to different versions of the same product. I need these exported for display purposes, but they aren't gathered in anywhere convenient in our ERP software.

Also, for reference, I'm dealing with well over 1000 records that I'd like to consolidate. Each "Product" having 3-4 "versions"


Hopefully my answer will expound on the original question, and help get a resolution for both myself and DCV! Thanks so much for taking the time to read!

[June7]

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

Don't yet know enough about DCV requirements to determine if this method applies.

[Siiig]

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

Don't yet know enough about DCV requirements to determine if this method applies.

Hey June7,

It seems like this will work for my purposes, but I'm having trouble implementing it into the database.


Would you mind taking a look? I recreated necessary information into a test database ^^; It must be something I'm doing wrong in the VB section, but I followed the instructions--and don't really have enough back knowledge to troubleshoot.

Getting the message "Undefined function 'ConcatRelated' in expression"

[June7]

I can't review db until after Feb 22.

Did you put the function in a general module? The module and function cannot have same name.

Where are you calling the function - in query or from textbox?

[Siiig]

Oh, I didn't know they needed to be named differently. That seems to have cleared at least part of the problem up.

I'm confused about the third argument in the function.

[Edit!]


Figured it out!