I have an Access 2007 table with two fields, ProductName and ProductSort:
ProductName / ProductSort
juice / cool
juice / tropical
juice / natural
cola / cool
cola / artificial
And I want it to become like this:
ProductSum
juice, cool, tropical, natural
cola, cool, artificial
..etc
In other words, the ProductName field should be merged with the ProductSort field to a new textfield called ProductSum with ProductName and all related ProductSorts separated with commas (one uniqe product per row).
Is this possible by using a Query? If not how?