Access 2003 Query - combine rows

In Progress Posted Aug 5, 2011 Paid on delivery
In Progress Paid on delivery

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

Project ID: #1154217

About the project

1 proposal Remote project Active Aug 5, 2011

Awarded to:

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 in 1 day
(0 Reviews)
0.0