Ron Adams wrote:
I'm playing around with using RANK and/or ROWNUMBER functions in a
query, but I keep getting the error message "Function not supported
for query"

There are some limitations on SQE queries, which is what is needed for OLAP. Birgitta had a nice post on it:

Danke schön, Birgitta!

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact