>>Hello,
>>I need to show the contents of a table like a spreadsheet.
>>The table is structured like:
>>Color Size Order
>>001 S 10
>>001 M 5
>>001 L 6
>>002 S 8
>>002 M 9
>>
>>The grid (or whatever) should reflect the contents like a spreadsheet:
>>
>>Color S M L
>>001 10 5 6
>>002 8 9
>>
>>The difficult part is, that the spreadsheet is editable (if the user changed the Number of orders, I want to change it in the table), and that the number of columns (and their names) vary according to the existing records. This means, if no size L exists for a selection, this column should not show up.
>>Any ideas??
>>I would be very happy, if someone could help me to find a solution.
>
>Can you create a CROSS TAB Query? That will total to one line by color and size. Make that a source for your grid and Poof i think that you are done.
>
>This is not editable back to your raw data though, it's more of a reporting on stock approach.

That's exactly my problem, I have to get this editable. So that's not an easy one?