Hi,
Thank you for the reply.
I added two more conditions to the WHERE Clause. My code looks like this:
Code:
For ICount = 8 to 1 Step -1
.... Code
strSQL = INSERT INTO table1 (col1, col2, col3, …)
SELECT col1, col2, col3, …
FROM table2
WHERE fkYears =" & Me.cboSYear.Column(0) & " AND DateDeparted Is Null AND Col3 = " & ICount;
.... Code
db.Execute strSQL, dbFailOnError
NEXT ICount
In relation to dropping the For Cycle, I need to execute the following code after each strSQL:
Code:
db.Execute strSQL, dbFailOnError
Will it execute it if I use the suggested BETWEEN 1 AND 8 ?
Khalil