Looping process

[GW]

Hi Experts,

I’m trying and learning to write a codes in access. Appreciate if you could
show me
how write the code for the looping process. I can create a query or a macro
but
what if there are thousand of group of data in that particular field and the
data is
not consistent eg 100...120,130...150,160...250. I want to export the data to
multiple excel files based on all group of data in that particular field at
one time eg.
for 100 to 100.xls....250 to 250.xls.

Please guide or possibly give me a sample to do this.

tq.

 

[Alex Dybenko]

i think you cn try to use a for-next loop:

dim i as integer

for i=100 to 250 step 10
'do something using i value

next i