I have the data in the small test database attached. I can write a query that sums up by Employee,DOS and ID. However, I can't find a way to get the code numbers to come along and sit on the same line.
In other words, when Chuck is summed up he will have only 1 line. I want the three codes to be on the same line. Same with Bob. Is there a way in query to do this?? I tried to put the data here but it won't line up so I had to attached a small database. Any help is appreciated.