Cross Tab for Data Entry

[mattc66 via AccessMonster.com]

I am working on a Forecast Tool for our company.

Item Jan Feb Mar ....Dec
Widget 100 200 100....
Widget2 50 100 100....

So I created a Table as follows:
ITEM
DATE (Which is the 15th of every month)mmddyyyy
QTY

I created a Cross Tab Query thinking I could then base a form on the query
for the planner to do the Forecast scheduling. It's not working.

How do I lay out the query or is this not possible and only for reporting
puposes?

 

[Rick Brandt]

I am working on a Forecast Tool for our company.

Item Jan Feb Mar ....Dec
Widget 100 200 100....
Widget2 50 100 100....

So I created a Table as follows:
ITEM
DATE (Which is the 15th of every month)mmddyyyy
QTY

I created a Cross Tab Query thinking I could then base a form on the
query for the planner to do the Forecast scheduling. It's not working.

How do I lay out the query or is this not possible and only for
reporting puposes?

Exactly. No query that does aggregating is editable. Each field represents a
summation of records so where would the edits go?