Looking for some help again. I have a table that stores training records so if employee A went to training they enter the data on a form and save it so a new record is created in this table. Now if employee B goes to the same training later that year it creates another record in the table. Now through some queries I am able to make another table look like I have in the example picture provided. But when I create a report and group by the training I get 6 rows since there are the 6 records. I was hoping to combine the records through queries or maybe another way so that they can be grouped so that I would really only have 2 rows one for Mike and one for John. I appreciate any help. Thanks.
Combine Rows
- Thread starter djs
- Start date
- Local time
- Today, 10:04
- Joined
- Aug 30, 2003
- Messages
- 36,281
I can't look at the attachment right now, but it sounds like you want this type of thing
http://allenbrowne.com/func-concat.html
Either that or a cross tab query, which has a wizard you cn play with.
http://allenbrowne.com/func-concat.html
Either that or a cross tab query, which has a wizard you cn play with.
I knew it would be something easy but I have never used crosstab queries before but that is exactly what I needed. Spent alittle bit of time reading about them and was able to create the reports which my boss has been asking me about. Thanks your a lifesaver.
