Query Help

[Lee-Anne Waters via AccessMonster.com]

Hi,

i have a table called orders and another table called techs.

in the techs table there is a field called capacity

the order table needs to have techs assigned to them each day. so if a tech
has a capacity of 5 then i want to assign him 5 orders for that day. at
present i have to click on each order to assign.

is there a way of having the database look at his capacity of 5 and assign 5
orders. keeping in mind that a capacity is variable and could be 0 to 10

any help please
thanks
Lee-Anne

 

[Michel Walsh]

Hi,


If the capacities can be described like a running quantity:

Who Low High ' fields
John 1 5
Ann 6 13
Joe 14 16 ' data sample


then you may desired to rank the jobs to automatically find who does what.
Sure, if there is only 3 jobs, that means only John will be busy. Another
way is to explicitly assign the sequence:


Who JobNo
John 1
Ann 2
Joe 3
John 4
Ann 5
John 6
Ann 7
Joe 8
etc. The first job to enter goes to John, the second to Ann, and so on.
Since Joe can only do 3 jobs, the 6th job is given to John (arbitrary, since
you are in charge to define the sequence of attribution, supplying data in
the table).


Hoping it may help,
Vanderghast, Access MVP