Dear VB users,

In the next rows you can calculate via SQL the average & the sum.
But where can I find the result?

'Calculate the average
Set RS = DB.OpenRecordset("select avg(MyField) from MyTabel") '
RS.MoveLast
'RESULT ? ? ? ? ? ? ? ? ?

'Calculate the sum
Set RS = DB.OpenRecordset("select sum(MyField) from MyTabel ") '
RS.MoveLast
'RESULT ? ? ? ? ? ? ? ? ?

Thanks for your information.

Nice regards,

Michelle.