I want to create a table that has a structure similar to the following:
Month Type Value1 Value2 Value3
Jan 001 1000 3000 2000
Feb 001 1500 3500 2500
However I would like to be able to EDIT the date in the following format in subforms by Type
Jan Feb ..... Dec
Value1 1000 1500 ......
Value2 3000 3500 .......
Value3 2000 2500
I think I can display the data using a crosstab query in a form but that renders it non-editable. Is there any way for a beginner to accomplish what I want to?