need help

[dansalmada]

need help, please anyone?

I've tried to do this operation in ms access, kind of forecast the next 6 months or so.

I can only get the first value and the rest appear as zero

Here is an example of what I need to do, in Excel

Help!!

 

[ByteMyzer]

The Excel file gives an excellent illustration of your attempted end result. Can you also attach a copy of the .MDB file you with which you are attempting to accomplish this?

 

[dansalmada]

DB Example

Attached is my DB with which I'm trying to reach the data seen in the Excel Sheet

Thanks for your help

 

[ByteMyzer]

Your field labelling scheme is as clear as mud, so I went ahead and attached a sample database with a table, Table1, as a model after your Excel example, and a Macro, UpdateForecast, which performs the calculations and updates the appropriate fields on the fly. The Visual Basic code is viewable in the Module modUpdateForecast.

See if this method is usable to you.

 

[dansalmada]

Absolutely Incredible!!

Thanks a lot, really, it worked great

I only have one more question

I need for the function to start forecasting from the first value that is "0". I don't want it to overwrite my real values I already have, this function uses the first value and forecasts the rest, but what if my first and second value are real and I need from the third value on (on the global sales column)