[AccessD] Trimmean Function in Excel - How to in Access

Julie Reardon-Taylor prosoft6 at hotmail.com
Tue Apr 11 07:53:13 CDT 2006


I'm trying to trim my dataset in Access so that I drop the top 10% of the 
data as well as the bottom 10% of the data so that I can get rid of 
extraneous values that may skew the results.  I know that in excel, I can 
use the trimmean function to do this.

Can't find an equivalent in Access.  Any Suggestions?



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
44 Public Square Suite #5
Watertown, NY 13601
Phone: 315.785.0319
Fax: 315.785.0323
www.pro-soft.net
NYS IT Services Contract CMT026A
NYS Certified Woman-Owned Business





More information about the AccessD mailing list