I have an access file of all the tasks of the employees.
I want to make a query of group by
on two columns:
- Employee Name
- Date
Sometimes I have couple of tasks each day and I want them to concatenate them into one cell.
I tried to do group by with "&" operator but it is not working.
Example:
I would truly appreciate ideas and solutions.