Crosstab/Form

[Guest]

Hello,

I have a table in the following form:

Center Amount Date
Dal 5.00 200401
Dal 7.00 200402
Dal 8.00 200403
San 2.00 200401
San 3.00 200402
San 4.00 200403


I would like the users to be able to edit the values using a form, but I
would like the dates and values to be going accross. This would be similar to
a crosstab query, however I would like the form to do this and then update
the table when they hit the OK button.

Any suggestions would be appreciated on the best method for doing this.

Thank You,

 

[Guest]

Sorry I didn't specify the end result.

I would like the form to be displayed as:

Center 200401 200402 200403
Dal 5.00 7.00 8.00
San 2.00 3.00 4.00

Allowing the users to edit and update in this form format

Thanks