Hi,
I am trying to run a loop through a recordset which will return records into excel based on the value of a field. Each time that value changes it will move down 2 more rows and continue, eg:
In Excel looks like...
Col1 Col2
x abc
x def
y ghi
y jkl
y mno
etc..
I believe this is a nested loop and I have had succes of sorts but I can't get the complete recordset to output.
Any advice would be much appreciated.
Cheers,
P
I am trying to run a loop through a recordset which will return records into excel based on the value of a field. Each time that value changes it will move down 2 more rows and continue, eg:
In Excel looks like...
Col1 Col2
x abc
x def
y ghi
y jkl
y mno
etc..
I believe this is a nested loop and I have had succes of sorts but I can't get the complete recordset to output.
Any advice would be much appreciated.
Cheers,
P