Prioritize accounts

[jhicsupt]

I need to prioritize accounts that we can work on. I need to be able to put
in the capacity per month for two categories. Then I need to choose the # of
accounts per the capacity for each month.

For instance -
In May, we can work on 2 large accounts and 2 small accounts
In June, we can work on 4 large accounts and 4 small accounts
In July, we can work on 4 large accounts and 1 small account

I will have a table [tblcapacity] that will have the capacity for the months
with the below fields:

Month Large Small
05-09 2 2
06-09 4 4
07-09 4 1

Now I need to take the top accounts and put "05-09" in the [prioritization]
field in my query. So I would need the top 2 large accounts (ranked by
numerical value) to have 05-09 in the [prioritization] field and the top 2
small accounts to have 05-09 in the [prioritization] field.

Then I need to take the next 4 large accounts and have 06-09 in the
[prioritization] field and the next 4 small account to have 06-09 in the
[prioritization] field.
and so on...

So my query would look like:

Customer Ranking Prioritization
ABC (large) 1 05-09
XYZ (large) 2 05-09
TTT (small) 3 05-09
123 (small) 4 05-09
and so on...

Hopefully this gives enough information. I'm not that great in Access, so ...

Thanks in advance.