Performing calcs in a recordset

jimmyclams · Dec 3, 1999

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.

WP · Dec 5, 1999

Since a recordset can be based on an SQL string you can use the SQL functions min, max, avg etc. 
 
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 <a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a> <a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a>

jimmyclams · Dec 6, 1999

WP, 
 
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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Performing calcs in a recordset

jimmyclams

Programmer

WP

Programmer

jimmyclams

Programmer

Similar threads

Part and Inventory Search

Sponsor