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

Julie Reardon-Taylor prosoft6 at hotmail.com
Tue Apr 11 08:31:48 CDT 2006


Thank you Lambert and Jim.   I was trying to use aggregate functions similar 
to the following formula that I have used in the past in Excel:

=(SUM(A1:A5)-MIN(A1:A5)-MAX(A1:A5))/MAX(1,COUNT(A1:A5)-2)

and was having some trouble with getting the system to do what I need.

Thank you for your help.  Thought maybe there was a function that I didn't 
know about.

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