Heenan, Lambert
Lambert.Heenan at aig.com
Tue Apr 11 09:17:10 CDT 2006
On further thinking about this, if you go the two query route then you should of specify that you want the top 88% in the second query which will leave you with the middle 80% of the whole data set. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Julie Reardon-Taylor Sent: Tuesday, April 11, 2006 9:32 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Trimmean Function in Excel - How to in Access 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com