Merging multiple query results into one row

[Guest]

I currently have a database set up showing companies and the departments I
deal with. The companies and departments have there own table with a third
table giving a relationship between the two.

I want to write a query that will return one record showing all
departments for that company rather than what I'm currently getting which is
a record per company per department.

 

[John Vinson]

I want to write a query that will return one record showing all
departments for that company rather than what I'm currently getting which is
a record per company per department.

So you want all the departmentnames on one line, say separated by
commas?

You'll need some VBA code. See

http://www.mvps.org/access and search for "Concatenate".

John W. Vinson[MVP]