Skip to content

Tag: concatenation

SQL query to CONCAT/list unique column data if rows have identical data in the other columns?

Thanks in advance. I’m basically trying to run a SQL query so that the results are 1:1:1:1:Many for StaffID:Name:Floor:Date:Shifts. Here is my initial query and example results: I then combined the ShiftStart and ShiftEnd columns with the following to get the further below results: What I can’t figure out to do next though is to combine Andrew’s shifts (and anyone

Combine cells in access separated by comma

I am new to access and coding. I have a sheet comprising of huge data. I want some specified data in Access by running a query or VBA. What I want is to combine the data based on a column and each data separated by a comma. I am pasting the example of the sheet below: Input sheet Output data