>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.