Complicated Data Entry Form (Sales forecasting)

[Guest]

I've run into a problem

I am trying to build a data entry form that allows a user to input sales forecast information. The sales need to go forecasted by week. How do I display the weeks going accross in access? I need it to be dynamic enough so that a user can select the weeks they want to work in. Each of the weeks need to capture the quantity, price and gross margin. the underlying record will hold the Salesperson, customer and item being forecasted

So.. A user enters a Salesperson, Customer and item they want to forecast. Then it prompts them for the weeks (going accross) so they can enter the quantity, price and gross margin

Any ideas on the best way to do this

thanks
Bradley

 

[Guest]

More Info ...

When a user enters data I want them to see something like this:

Item -- Sales Person -- Customer ---- January -- March -- April -- May -- June -- July -- August -- etc...

For each month I want them to fill in the ForecastQty, price, gross margin.

Any suggestions on ways to do this?