can you do Forecast Function in ACCESS?

G

Guest

I would like to do projections or use something along the lines of MS EXCEL's
Forecast or Trend feature to make projections for the future. Is this
possible in ACCESS or is there a code I can use in VB?
 
J

Jeff Boyce

A couple of options...

You can extract the data you wish to use for trend/forecast via a query,
then export that query (data) to Excel for analysis.

You can set a reference to the Excel function via a code module.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Function Error 1
Advanced Filter used with merged cells? 1
Composite moving averages in forecasting; fairly accurate-- even with fairly random actual sales fig 4
Projections Formula 1
Forecast Table 9
Linear regression in MS Access 3
report 1
Changing line appearance for future values 4

Top