Hello everyone,

I am having a problem when merging into word from Access. 

I am trying to set up a document that is a work diary that merges from access. The first 3 columns are ID, Day and Date and the next 30 columns are the names of the staff members.

I want to be able to group by Staff Member so that all the jobs are shown together for each date I.e. Staff Member 1 – Monday 01/01/2024 08:00 Job 1 13:00 Job 2 / Tuesday 02/01/2024 – 08:00 Job 1 13:00 Job 2 / Wednesday 03/01/2024 08:00 Job 1 13:00 Job 2 Thursday 04/01/2024 – 08:00 Job 1 13:00 Job 2 then  Staff Member 2 – Monday 01/01/2024 08:00 Job 1 13:00 Job 2 / Tuesday 02/01/2024 – 08:00 Job 1 13:00 Job 2 / Wednesday 03/01/2024 08:00 Job 1 13:00 Job 2 Thursday 04/01/2024 – 08:00 Job 1 13:00 Job 2 etc.

Please can someone help!

​Hello everyone, I am having a problem when merging into word from Access.  I am trying to set up a document that is a work diary that merges from access. The first 3 columns are ID, Day and Date and the next 30 columns are the names of the staff members. I want to be able to group by Staff Member so that all the jobs are shown together for each date I.e. Staff Member 1 – Monday 01/01/2024 08:00 Job 1 13:00 Job 2 / Tuesday 02/01/2024 – 08:00 Job 1 13:00 Job 2 / Wednesday 03/01/2024 08:00 Job 1 13:00 Job 2 Thursday 04/01/2024 – 08:00 Job 1 13:00 Job 2 then  Staff Member 2 – Monday 01/01/2024 08:00 Job 1 13:00 Job 2 / Tuesday 02/01/2024 – 08:00 Job 1 13:00 Job 2 / Wednesday 03/01/2024 08:00 Job 1 13:00 Job 2 Thursday 04/01/2024 – 08:00 Job 1 13:00 Job 2 etc. Please can someone help!   Read More

​