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: [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/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.
