complex report using VB

[Marshallp24]

Hi,

could someone please tell me if this typr of report is possible:

I have a list of about 3000 clients that have been given a score based
on their proformance 1 to 10. I have split them of into groups 1 - 3
is low, 4-7 is medium and 8-10 is high.

I want a report to select 80% of highs, 15% of meds and 5% of lows,
thats percents of what every the user wants. So a user promt would ask
how many they needed, they user puts in 100 and gets a list but with
those percents from them groups and is there isnt 80% of 100 in the
highs to take them from the meds.

Is that possible? How to do it?

2nd part is, after the 1st user promt, I want a 2nd user promt to ask
how many staff? So it divides the number of clients in the list by the
number of staff, then splits the report over however many staff there
are.

Again is that possible?

3rd part is, after is asks how many staff, its asks their names (but
is has to ask 4 times if the user said 4 staff), puts that name at the
top of each page of the report.

Possible? How difficult? I'd imgine some sort of loop statement.

Please tell me if I'm asking too much of access.

Thanks!