Access 2003 Query - combine rows

進行中 投稿 Aug 5, 2011 着払い
進行中 着払い

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.

マイクロソフトアクセス

プロジェクト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