Merging multiple query results into one row

[Guest]

I currently have a database set up showing companies and the departments I
deal with. 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.

 

[Guest]

Hi

Are your departments stored in a table with a field that corresponds to the
company (joined) or do you one table listing both the department and company.

Can you send a little more information regarding the table setup

 

[John Vinson]

I currently have a database set up showing companies and the departments I
deal with. 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.

Care to describe your table structure? The answer should be
straightforward, but only if we know what you're starting with.

John W. Vinson[MVP]

 

[Guest]

There are seperate tables for company and department that are joined through
a third table.

Hope this helps.