StDev for previous "n" records

[JGLogsdon]

I am somewhat familiar with Access, but stumped by calculations. I am trying to create a rolling stdev and avg based on the previous ten records (if there are not ten records, it would take the total number of records and perform the same calculation) of a table. Here is an example:
I have the following factors of : If I do a stdev {StDevOfNew Meter Factor: StDevP([qry_Factors].[New Meter Factor])} it would use all factors. I need to rolling stdev based only on the last ten. Any help would be appreciated.

1.00241.00261.00261.00241.00271.00231.00251.00261.00291.00251.00291.00281.00281.00291.00261.00331.00291.00301.0029

 

[jdraw]

http://bytes.com/topic/access/answers/728186-standard-deviations-microsoft-access

This link may help

 

[JGLogsdon]

Thanks for the quick response jdraw, but I am not sure how well the information in the link would work.

Just to clarify, the numbers are in one column, and the table could have 1000's of factors, so I am looking for a rolling stdev and avg based on the previous 10 factors.