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?