I have a table that contains records of job allocations with fields for Date, Job number, Client name, Site name, Engineer's initials.
Currently, if a job is allocated to a team of, say, three engineers, there will be three records for each day of the job duration - one record for each engineer - with all fields holding the same data except for the date field and the field which holds the engineers initials. So, a job with a duration of three days would have three records for each of the three days.
I would like to combine the details for display purposes so that the common data is only shown once per day and the Engineer field shows collated data of the initials from all three engineers (eg BL/MF/VA).
Is there a tidy way to do this with a SELECT query or is it only possible using a loop to scan and extract/concatenate into a new table/cursor?
Currently, if a job is allocated to a team of, say, three engineers, there will be three records for each day of the job duration - one record for each engineer - with all fields holding the same data except for the date field and the field which holds the engineers initials. So, a job with a duration of three days would have three records for each of the three days.
I would like to combine the details for display purposes so that the common data is only shown once per day and the Engineer field shows collated data of the initials from all three engineers (eg BL/MF/VA).
Is there a tidy way to do this with a SELECT query or is it only possible using a loop to scan and extract/concatenate into a new table/cursor?