Well I'm cheating a bit as really this is really being designed for Excel but I've found no solutionson nested queries like this anywhere.
The procedure I'm trying to carry out is pretty simple in theory, looping through the recordset and grouping result so that when the value in a field...
Spikepl,
Still not loving the loops unfortunately;
Currently I have:
Do
x=rs!x
Do while rs!x=x and not rs.eof
[Statements]
rs.movenext
Loop
rs.movenext
Loop
but still returning the 3021.
Have tried several variations on this but no success. Any...
LeagueOneDale,
Having the same problem with almost identical coding, what did you change to get the loop to run without error? I have been using something along the lines of:
Do While Not rs.eof
x = rs!x
Do While rs!= x and Not rs.eof
rs.MoveNext
Loop
rs.MoveNext
Loop
Cheers,