I'll do free VB 6 projects.

I'll do VB6 projects for free depending on how much time it will consume.

Dear JOP,
Could you help out a local school board in Tennessee (USA).
I'm swamped with for pay work and have a friend at the school that needs this. Really simple if you could help. I'll place a link to you on my website in appreciation if you'll do this one...

Data Source: msn_stu_data
Table Source: msn_gpa
Fields:
Stu_ID
School_assigned
gpa_div
School_1
School_2
School_3
1_total
2_total
3_total
1_ok
2_ok
3_ok
Total
Total_ok


query field [gpa_div]
count and seperate by gpa
3.7 or greater
3.5 or greater but less than 3.7
3.2 or greater but less than 3.5
3.0 or greater but less than 3.2
2.8 or greater but less than 3.0
2.5 or greater but less than 2.8

Get total number of students for each category

divide each category by 1/3

assign students in each category equally amongst 3 schools
write next to each student ID the school they will attend in "School_assigned"

If extra students exist in each category that cannot be divided equally
Then assign extra students to schools in cascading order
(in other words...5 students have a gpa of 3.7 or greater.
the first 3 are assigned and then the remainder are assigned
starting from the first school and working down. In the next category
there are 4 students...the first 3 are assigned from the first school
and then the last one is assigned to the school that previously
did not get an equal division from the first category. In this
instance the 3rd school. So each school now has a total of 3 students
each and a total of 9 students assigned.)

After completed then:
Write to 1_total/2_total/3_total the total number of each students assigned
Write to a label for each school the percentage that total represents.
If those percentage totals are equal write to "1_ok/2_ok/3_ok" "OK" next to each

school

Add all the three school percentages...if they equal 100%
Then write to "Total_ok" "Yes"
Write total number of students to "Total"

Sample Data:



ID
GPA_Div

350
2.5

331
3.0

344
2.5

336
3.0

345
3.5

333
3.0

340
2.5

343
3.0

341
3.5


School_1
3
33.3%

OK

School_2
3
33.3%

OK

School_3
3
33.3%

OK


Total
9
100.0%

Master_Ok
OK




Thanks for any help with this!
MCPC.biz