Backward For Loop in VBA Access? 1

[VBUser77]

I am trying to execute this code:

dim i as variant
dim count as integer

For i = 3 to 1

count = i+2

Next i

It works when I say for i = 1 to 3.

Any ideas or thoughts how to run a for loop with decending values like for i = 3 to 1?

Thanks a lot in advance.

Jay

 

[jebry]

Hi Jay!

Try For i = 3 to 1 Step -1

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[VBUser77]

Thanks a lot.

 

[1DMF]

Just a thought, if you are using i for an integer loop, is there a reason why you have defined it as variant?