SaladProblems
Active Member
- Joined
- Apr 9, 2010
- Messages
- 279
Hi, I'm not sure of the best order to list everything, but here's the query I'm working with and its result:
What I would like to do is generate a query that will list each company once and then concatenate all of the descriptors the next field with tildes. In this example it would be:
1170 BROADCASTRADIO INC, PUBLIC RELATIONS~COMMUNICATIONS CONSULTANTS~ADVER....
The data is coming from http://www.nylovesmwbe.ny.gov/cf/search.cfm - the DB I'm using can be downloaded directly from there, and the reason why I want to concatenate it like that is our own database which I don't want to risk damaging by running queries takes information on an Excel sheet in that format.
It's not a big deal for me personally to export it as-is and then clean it up in Excel, but I would like to cut this down to one step for the people who will actually be using it - it'll be done at least once a month indefinitely so I'm aiming for a repeatable solution.
There aren't enough descriptors per company to reach 255 characters, and I'm using Access 2010 - I converted the mdb they have to an ACCDB, and the key field ID_num is set to text in the first table and is numeric in the others in case you download it and mess around with it at all.
I apologize if this problem is a dead horse - I've tried a few solution with limited results, and found a couple of threads on this site with expired links, but a consistent solution has been elusive for me.
What I would like to do is generate a query that will list each company once and then concatenate all of the descriptors the next field with tildes. In this example it would be:
1170 BROADCASTRADIO INC, PUBLIC RELATIONS~COMMUNICATIONS CONSULTANTS~ADVER....
The data is coming from http://www.nylovesmwbe.ny.gov/cf/search.cfm - the DB I'm using can be downloaded directly from there, and the reason why I want to concatenate it like that is our own database which I don't want to risk damaging by running queries takes information on an Excel sheet in that format.
It's not a big deal for me personally to export it as-is and then clean it up in Excel, but I would like to cut this down to one step for the people who will actually be using it - it'll be done at least once a month indefinitely so I'm aiming for a repeatable solution.
There aren't enough descriptors per company to reach 255 characters, and I'm using Access 2010 - I converted the mdb they have to an ACCDB, and the key field ID_num is set to text in the first table and is numeric in the others in case you download it and mess around with it at all.
I apologize if this problem is a dead horse - I've tried a few solution with limited results, and found a couple of threads on this site with expired links, but a consistent solution has been elusive for me.
Last edited:
