Performing calcs in a recordset
Performing calcs in a recordset
(OP)
Is there a way to perform calculations to a recordset? For example min, max, avg? I can do that in an array, but there has to be a better way than copying recordset elements to an array ( which I can't figure out anyway). Any help would be much appreciated.
RE: Performing calcs in a recordset
There are many examples of this in the MS ACCESS help files. Search for "min", "max", "avg" etc and look at the DAO example.
Hope this helps.
WP
Bill Paton
wpaton@neptune400.co.uk
www.neptune400.co.uk
RE: Performing calcs in a recordset
I found those examples and they were a great help, thanks! Any idea on how to get a set of elements from an SQL statement into an array?
Thanks in advance.
MC aka jimmyclams