Combining Data in an Access Query using builder function

[Barry83]

Hi have a table in Access 2010 and in one field i have multiple records of the same data as in the next field it has unique data for example:

Name Colour
Car Blue
Car Green
Car Yellow
Bus Orange
Bus Purple
Bus Red

I am trying to run a query which will effectively group up the "Name" field and combine the "colour" field against the name using a ";". so it would look like this:

Name Colour
Car Blue;Green;Yellow


do you know how i would do this.

 

[pr2-eugin]

Hello Barry83, Welcome to AWF

You need the function by Allen Browne called Concatenate values from related records

 

[Barry83]

Thank you Paul, that worked perfectly. I am upskilling myself in the builder module so I really appreciate your help.

Cheers
Barry

 

[pr2-eugin]

No problem ! Good luck.

 

[Barry83]

Paul, sorry to be a pain. I have just one table now instead of two separate tables. Would this be the same function with the exception of the FROM table text at the end?

 

[pr2-eugin]

I have not tested it, maybe you could test it for me.

Yes, replace the name of table, with the current table.