looping problem

[maria_arif]

hello to all experts there..

i got a big problem with looping here.
my problem is like this:


i have make an sql statement to count students in each class like this. i'm using VB6.0:

select class, count(*) from classes where year='1999'
order by class

and the output is like this:

classA = 10
classB = 5
classC = 0

i want to relocate students from classA to class B and C where i take 3 students from classA to

classB and 2 students from classA to classC and it become like this. the relocation is done with

the value i put in the text box:

classA = 5
classB = 8
classC = 2


and after the relocation was done, each student will get their id number based on their class and

number of students for each class where the output is like this:

classA
______

A001
A002
A003
A004
A005


classB
______

B001
B002
B003
B004
B005
B006
B007
B008

classC
______

C001
C002

how to do it? i really don't know. hope you guys could help me here and i really appreciate for

any help given. Thank you

[rdove]

Sorry, we don't do ppl homework here. Try to come up with some code and test different things. If you can show an effort that you attempted to code this, post your code and we shall see what we can do.