Hi Allen,

first thank you for the explanation off the gomonth()-problem, but we

are in old Europe ;-)

For the median a SELECT DISTINCT don't gives the right value!

The Skip is much more easy but returns only the median in uneven counts

of records.

Dr. Joerg Arand

Consultant Neonatologist

Neonatology

Children's Hospital

University Tuebingen

Calwer Str. 7

D-72076 Tuebingen

Tel.+49-(0)7071-2982211

Tel.+49-(0)7071-2980895 (office)

E-mail:Joerg.Arand(AT)med.uni-tuebingen.de

>>> "Allen" <profox@gatwicksoftware.com> 15.04.2014 13:25 >>>

Hi Joerg

That is about what I did, but distinct TTOD in the select. I am going

to

test speed though it's not a big deal. The skip is simple and I hope

faster.

Will play.

Thanks

Al

-----Original Message-----

From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of

Joerg

Arand

Sent: 15 April 2014 13:14

To: profoxtech@leafe.com

Subject: Re: halfway down a set order

Hi Allen

For the median do:

select datefield from table into cursor curtemp order by datefield

lnrecord=_tally/2

go lnrecord in curtemp

IF mod(_tally,2)=1

skip in curtemp

retu datefield

else

lndatetime1=datefield

skip in curtemp

return lndatetime1+(datefield-lndatetime1)/2

endif

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance:

http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list:

http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message:

http://leafe.com/archives/byMID/profox/008501cf589d$5d2d18a0$178749e0$@com

** All postings, unless explicitly stated otherwise, are the opinions

of the author, and do not constitute legal or medical advice. This

statement is added to the messages for those lawyers who are too stupid

to see the obvious.

Report [OT] Abuse:

http://leafe.com/reportAbuse/008501cf589d$5d2d18a0$178749e0$@com

--- StripMime Report -- processed MIME parts ---

multipart/mixed

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/534D370F0200002D00055682@gwia1.zit.med.uni-tuebingen.de

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.