I'm still not sure what error you get. Show me the code and where the error occur.
Alternatively (the long way around), have separate recordsets for each month, i.e. -
Dim con As ADODB.Connection
Dim rsJan As ADODB.Recordset
Dim rsFeb As ADODB.Recordset
Set con = New ADODB.Connection
con.Open "........your connection here...."
Set rsJan = New ADODB.Recordset
rsJan.Open "SELECT * FROM January", con, adOpenStatic, adLockOptimistic
rsFeb.Open "SELECT * FROM February", con, adOpenStatic, adLockOptimistic
'And so on...
Need some help with this Array. I am trying to get the sum of the even numbers and the sum of the odd numbers using a for each loop. I know the answers to what I am trying to achive are sum of even = 84 and the sum of ...
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...