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

Heenan, Lambert Lambert.Heenan at AIG.com
Tue Apr 11 09:56:15 CDT 2006


Well I'll try. :-)

Say you have exactly 100 records, so your goal is to get the middle 80
records in your result.

The first query returns the "top 90%" of the data, so it should be sorted in
ascending order so that the query will return records 1 to 90.

Then you use that query as the input to the second query. The second query
sorts in descending order (90, 89, 88...) and its Top property is set to
88%, which should give you a result of records 90 to 11.  Why 88% ? Well the
first query returns 90% of the original records and you need to lose the
bottom 10 records which is 10/90% which is roughly 11.11%. By trying it out,
if the second query returns 89% or records you get 81 out of the original
100, but if you set it to 88% you will get 80 records.

HTH

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 10:45 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Trimmean Function in Excel - How to in Access


Hi Lambert,

What is your thinking on this?  Can you explain?



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



More information about the AccessD mailing list