Flatten a one to many relationship result in a query

J

JELLA

I have a one to many relationship that results in
duplicating values in a query for each parameter defined
by the relationship. Is there a way to flatten or 'roll'
this up? For example a query that joins a car models
table to a car colours table repeats the all the car
models for each different colour value. Is there a way to
flatten the query so that for each unique car model, the
colour field is comma delimated?

I have been puzzled by this problem for months - and I'm
sure there must be a simple answer.

Thank you for your kind help
JP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I flatten data in a one to many relationship? 1
Query with one to many relationship 2
displaying a one-to-many relationship in one table 3
Query with 3 tables with 1 to many relationship 7
SQL query with Many-To-Many relationship??? 2
Can I edit data in a query with a one-to-many relationship (2000) 1
table relationship in query 1
recursive relationship query question 8

Top