I have all our products listed in a table. I need a query to combine same products, and combine available size's or colors to one field.
See attached example.
It is not important what sign is used to separate the available choice's. PrisUt and Products_name, should be the same on all products, but if not, it should pick the highest PrisUt value, and Products_name, just pick one.
Products_model should be the referance point of the query.
The reason why i need the query, is that i need a productlist that is easy to copy and paste to other programs.
That won't be a problem. Honestly you probably can work this out for yourself, however we'd be happy to help. It will involve us writing two queries to get everything formatted as you wish.