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.

[ItsMe]

I don't use them but, have you tried building a Crosstab query?

[ranman256]

A pivot will get you there...sorta. After the pivot, it may require code to get you to the final output.

[recyan]

Don't know if below is what you are looking for

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

Thanks