Concate Multiple Rows

[tonysandhu3]

Hello,

I have a table something like this:
Category .. Item Number .. Item Description
Item1 ...... Number 1 ....... Description1
Item1 ...... Number 2 ....... Description2
Item2 ...... Number 3 ....... Description1
Item3 ...... Number 1 ....... Description3

It needs to output some thing like this:
Item1, Number1, Number2 .. Description1, Description2
Item2, Number3... Description1
Item3, Number1... Description3

The output info will go into Dropdowns for all three fields in a form.

Any help is extremely useful, stuck on this issue for few weeks. Could not find any thing online.

I am programming in classic asp and Microsoft Access DB.

[Old Pedant]

??? Do you mean your DATABASE table looks like that? Or your HTML <table> does?

If you mean the DATABASE table, then are you saying you need to have

<tr>
    <td>Item1</td>
    <td><select ...>
        <option>Number 1</option>
        <option>Number 2</option>
        </select>
    </td>
    <td><select ...>
        <option>Description 1</option>
        <option>Description 2</option>
        </select>
    </td>
</tr>

in the HTML output?

[tonysandhu3]

Thanks for the reply, I did figure it out.