Qry to put list of contacts in one single row

B

blueangel174

I'm new to this site, I thought I would see if anyone could help me since I'm
struggling with Access. I have a table with many companies' info and a table
with employee/contact info for those companies. I need to put the employees
in a single row next to the company they belong to. There may be one or
several employees titles, names to each company and I need to list them all
in one row (i.e. Smith Company, Jane Doe, HR, Bob Smith, CEO, George Jacob,
President. When I do a basic qry the company name is listed each time an
employee name is listed. i.e.
Smith Company, Jane Doe, HR
Smith Company, Bob Smith, CE0
Smith Company, George Jacob, President
 
T

TraciAnn

Is there a reason you are not using a report?

It sounds like you want to create a report based on the query and Group By
Company.

The Report Wizard will help you with the grouping if you aren't familiar
with it.
 

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 to join row data into one row 1
Convert Output of Query result field to a single field 4
Convert formula to work in diff areas of worksheet 2
Combining two list of data 3
Fast way to determine if a string contains a member of a list of strings 38
Unmatched in two fields 1
many to many then one to many 1
Employee Time Tracker 2

Top