Is this even possible?

[garywin]

Hi everybody,



I hope you are all well today. I have a bit of a complicated situation and I am thinking that it will require multiple steps, but I am looking to condense all transactions into as few queries and tables as possible. Here is the situation:

I am looking to draw data from two different tables and use a query to populate a 3rd table.

In the first table I have 3 fields of importance - Name, Course Abbreviation, and Course Number.

In the second table I have the additional fields - Name, Employee ID, Rank, email

For the third table I would like to group the data from the two tables by Employee and look something like this

Employee ID:Name:Email:Courses (this would be a combination of the Course Abbreviation and Course Number field. Also Employees have multiple courses over several records, so I'm looking to condense this).

For the rank field I am just pulling employees of a certain rank.

I have played with several styles and have been able to get my queries to pull the data I need, just not in the format I need. For example, I want all courses associated with one employee on one record. Is this possible?

[June7]

VBA code can be used to concatenate rows into one field. This might be convenient for display in a report but do not recommend saving data in this structure.

Google: access vba concatenate rows

Will get a lot of hits on this topic.

[pbaldy]

Here's one:

Return a concatenated list of sub-record values

I don't see another table, just a single query and a function.

[garywin]

Thanks for the tips. I'll see what I'm able to concoct with the new resources