Access 2003 Query - combine rows

В роботі Опубліковано %project.relative_time Оплачується при отриманні
В роботі Оплачується при отриманні

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.

Microsoft Access

ID Проекту: #1154217

Про проект

1 заявка Дистанційний проект Остання активність Aug 5, 2011

Доручено:

underwoods

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.

$30 USD за 1 день
(0 відгуків(-и))
0.0