Don't think old Europe has much sway on Microsoft. Sorry about that. And

Skip didn't work either. Don't know why but I am a bit fed up with it so

just used what I was doing. I'm not looking for a Median as such because of

the rubbish dates. What I am looking for is to see if the file is for a

particular airline season. So near enough will do it.

Al

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

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.

_______________________________________________

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/008f01cf58a3$aa2f3dd0$fe8db970$@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.