Please excuse the cross-post to both the Excel and Access
groups.
I have query, which returns a large group of start dates and
end dates
and I've calculate the number of days the job took. I need
a way to
analyze this group and only use the middle 95%. That is to
exclude the
extra high and extra low values. I also want to exclude
null values.
Some of these dates show the same start date and end date,
instead of
reporting a value of 0 for this record, I would like it to
report 1.
I'm not sure of how to begin this. I prefer to use Access,
because it
will be entered into an Access report, but can also use
Excel if it's
the best tool for this job.
Any help would be great!
Thanks in advance
Phillip Rosenkranz
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|