Trying to create Access query that will mimic an existing Excel spreadsheet

[Algal100]

Hi,



I am a novice Access user and not a programmer so I think this should be [I hope] an easy one! I have a very simple Excel spreadsheet that contains 2 formulas. I'd like to be able to generate the table in Access directly (instead of using Excel, then uploading or linking a table).

I have a list of companies and employee names (2 columns). The goal is to be able to have a cell that concatenates all the employees at the same company, separated by a comma, and a unique list of companies. Right now I use Excel....sort the spreadsheet by Company, put in the following formulas, then delete any rows where the cell in the "Last" column is blank:
[cell C2]: Name(s) = =IF(A2=A1,C1&", "&B2,B2)
[cell D2]: Last = =IF(A2<>A3,"Last","")
The result is being left with unique Company rows and the names of all the employees in one cell.

In the example below, there is one employee at Target and 2 at General Electric. Ultimately, I'd like to only see rows 1 and 3. Is there any way to program this in Access? Or some other crafty way to get the results I'm looking for? Thank you in advance!!

Company	Name	Name(s)	Last
Target	John Smith	John Smith	Last
General Electric	Amy Adams	Amy Adams
General Electric	Ed Miller	Amy Adams, Ed Miller	Last

[June7]

Need VBA code. Review http://allenbrowne.com/func-concat.html

Rather common topic. Here is one recent thread https://www.accessforums.net/access/...hip-50216.html

[A S MANN]

concatenates is very easy is query. You can use Distinct command to get only unique data