Hi,
I have following table:
Fields:
SKU ID
TransportID
WarehouseID
I am searching for a way to get the following result in a query:
when the SKU ID and TransportID in the next record is equal then ad the warehouse ID to a string.
For example:
SKU ID TransportID WarehouseID
12345 83 25
12345 83 30
Result:
12345 83 25, 30 (probably results in two rows in this case)