Performing calcs in a recordset

[jimmyclams]

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]

Since a recordset can be based on an SQL string you can use the SQL functions min, max, avg etc.<br>
<br>
There are many examples of this in the MS ACCESS help files. Search for &quot;min&quot;, &quot;max&quot;, &quot;avg&quot; etc and look at the DAO example.<br>
<br>
Hope this helps.<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

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

 

[jimmyclams]

WP, <br>
<br>
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?<br>
<br>
Thanks in advance.<br>
<br>
MC aka jimmyclams