Mika,
You might find the QueryRecordsets component I've been working on useful.
Its allows you to issue SQL queries against ADO recordsets. COUNT and MAX
are just two of the many builtin functions supported.
It lets you perform complex SQL SELECT statements including UNION, JOINS,
GROUP BY, HAVING, ORDER BY, sub-queries, functions, aggregates against the
ADO recordsets..
This component allows applications like Visual Basic 6.0 to register ADO
recordsets into a DataSet collection, perform complex SQL queries and return
the results as an ADO recordset.
For a trial download or more information, please visit
http://www.queryadataset.com/recordsets.aspx
Thanks
Adrian Moore
Peersoft
"Mika" <mi**@hotmail.com> wrote in message
news:OF****************@TK2MSFTNGP14.phx.gbl...
Is it possible to perform functions on a recordset (rather than on the
source database), e.g. COUNT, MAX etc
The reason I would like to do this is because I have a hugely complex view
which produces results with over 60 columns of data. I would like to
display all data but also highlight individual "cells" in the table which
have the highest (i.e. MAX) data for each column. I would also like totals
at the bottom of each column.
Obviously I could get the MAX value for each column by performing it on
the SQL data but that would effectively mean running the query twice and
would take twice as long.
Any suggestions?