How to join the result of a query as a string into another field. (1 Viewer)

[ponneri]

Hi All.

I have a peculiar requirement. There is a materials table that has multiple names for the same material id. (due to some need)

I have a query (group by) on materials table that runs fine and the result is as follows :

MatID, MatName

M123 Valves
M123 Valves X
M123 Valves Y

Now, i need to get only 1 MatID, the three MatName horizontally in two fields on maybe another table (to be later exported to excel)

ex: M123 Valves,Valves X, Valves Y
Z435 Pins1,Pins1.2, Pins2

so and so forth.

Hope I am clear. I need a solution asap.

Any help appreciated.

 

[pbaldy]

As answered elsewhere:

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

 

[ponneri]

Thanks. But is that the only way. No other built in function of formala in access sql ?

 

[pbaldy]

Not that I'm aware of.

 

[ponneri]

Thank you very much

 

[pbaldy]

No problemo.