In Progress

Access 2003 Query - combine rows

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.

Skills: Microsoft Access

See more: access rows, access 2003 combine rows, access query combine rows, combine rows access 2003, n query, query combine, access combine query, access 2003, rows, query table, combine, access query table, access table query, access combine rows, table size access, copy paste access access, query query, access table size, microsoft access point, copy access access, programs combine, access programs, access point, microsoft access 2003, query access

About the Employer:
( 6 reviews ) Sandnes, Norway

Project ID: #1154217

Awarded to:


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)

2 freelancers are bidding on average $30 for this job


Hello, I can give you the solution within 1 day. Thanks Imran Ahmed

$30 USD in 1 day
(0 Reviews)