access and excel functions

  • Thread starter Thread starter k2sarah
  • Start date Start date
K

k2sarah

i have an acces table consisting of ~3000 rows. i would like to calculate a
rolling standard deviation/kurtosis/skew and a slew of other excel functions
over 20 days. i am aware that i am able to call excel functions in ms access,
but as there will be 2980 calls for each function, it is extremely slow. can
you recommend a better approach.
 
Back
Top