The Member
Registered User.
- Local time
- Today, 14:27
- Joined
- Nov 2, 2001
- Messages
- 21
Young people of the universe,
At the moment I am working on a piece of code to calculate Variance.
The calculation procedure involve each member of the recordset minus the mean of the recordset (Xi - MnX, where Xi is the member of the Recordset and the MnX is the mean).
Using Recordset.edit and recordset.Upate I manage to make the calculation through but this means modification of the original data in the table that is just not cool.
So my question is... is there any way that I can make a copy of the Recordset and work off it in VBA without makeing a new table??
Many ta in advance.
JL
At the moment I am working on a piece of code to calculate Variance.
The calculation procedure involve each member of the recordset minus the mean of the recordset (Xi - MnX, where Xi is the member of the Recordset and the MnX is the mean).
Using Recordset.edit and recordset.Upate I manage to make the calculation through but this means modification of the original data in the table that is just not cool.
So my question is... is there any way that I can make a copy of the Recordset and work off it in VBA without makeing a new table??
Many ta in advance.
JL