If....then statements

[patelk]

below is the code i am working with and i am trying to make columns but
i am using a table. i am counting 11 problems from the database and
once i hit 11 i want to go to the 3rd column and start wrting the rest
of the problems but i cant seem to firgure out how to do that if even
if that is possilbe. right now the code types the problem up to 11
correctly but once it hits 13 it moves right to and starts typing the
problem in that cell but i want it to go to the top of the table but
use columns 3 and 4. Column 3 would put the problem and Column 4 would
put the count of the problem....Do i make any sense if so any ideas on
how to fix this?


problem_count = 0
Do While Not rs.EOF
problem_count = problem_count + 1
If problem_count = 11 Then
.MoveRight unit:=wdCell
.MoveRight unit:=wdCell
.MoveStart
Else
.TypeBackspace
.TypeText Text:=rs("timewhy")
.MoveRight unit:=wdCell
.TypeText Text:=rs("expr1")
.MoveRight unit:=wdCell
.MoveRight unit:=wdCell
.MoveRight unit:=wdCell
rs.MoveNext
End If
Loop

Any suggestions or examples would help alot. thanks