M
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?
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?