Using an excel formula in access 2000

[John Petty]

I have a trendline formula that I need to use in my database so as to
dynamically create some charts

The formula is : INDEX(LINEST(y,x^{1,2}),1)

Where LINEST calculates the statistics for a line using the least squares
method.
The Syntax for the function is Known y's, known x's, constant and stats).

How can I get this function to work in access? If I need to create a
function specific to access, can someone show me how?

Thanks,

John Petty

 

[MichaelRay via AccessMonster.com]

Check this MS KB article for how to call Excel functions in Access:
http://support.microsoft.com/kb/198571