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:[email protected]] On Behalf Of Joerg Arand Sent: 15 April 2014 13:14 To: [email protected] 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: [email protected] 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.
