report filter

I'm using Access 2000 to create a report that displays order
information for data entry. If there are 90 orders today and I have 4
associates available for data entry, I print the report and sort it
manually so each associate gets 23 or 24 orders.

I'm trying to find a way to automate this filtering. I'm thinking of
adding another field to the underlying table and update that field
with a 1, 2, 3 or 4. Then use that value to filter the report. I don't
know how to populate that field using a query.

The available associate quantity is not the same each day. Some days
there are two associates available. I could have up to 5 associates
available.

Any suggestions?

Dan