Join Multiple Records in One Table

[WebGodiva]

I'm a beginner and have some issues with a database i'm trying to create to merge into ms word documents.

i have two tables Inspectors and Projects. The Inspectors table contains all of the general information on the employee including the primary id of emp_no.

The projects table has all of the relevant experience for the employee broken into 6 fields with one of them being emp_no.

I have built the relationship between the two tables but (based on emp_no) what i need is to have all of the records for say emp_no 19 put into one table (this would include all of their relevant experience) from the project table.

when i try to query this, i get all of the same information from the Inspector file in a new table with the project information as 19-26 separate records.

What i was hoping to do was have it list the employee once and then all of their project information from the project table as one record not 19-26 sep. records and then merge that query with word. is there a way to do this?

thanks

"Never tell people how to do things. Tell them what to do and they will surprise you with their ingenuity." George S. Patton

 

[lespaul]

could you provide data samples from each table and what your expected results are from those samples?

thank you.

 

[WebGodiva]

Sorry, guess i should have included that upfront.

I have one table that has all of the employees project information:

Emp_No (relationship with general table)
Project_Name
Project_Location
Client
Year_Completed
Year_Built
Project_Role
Project_Description

I need four of those field to join into one field:

Project_Name, Project_Location (Client): Project_Description

I also have a table which contains all of the employee's general information:

Emp_No (Primary key is relationship with all tables)
Fname
Lname
Education
Registrations

What i want to do, is have all of the projects listed (in the projects table) for say employee number (Emp_No) 19 (from the employee table) all join with the general information into one table for future word merge. In other words to end up with a table that has:

Emp_No (Primary key)
Fname
Lname
Education
Registrations
Project_Combined (Project_Name, Project_Location (Client): Project_Description)

Thanks for any help you can offer - i'm learning the process and sometimes i just get frustrated when i know something is possible but i just can't figure it out.

Many thanks.

"One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn