R
Rick Neal
I am tring to put together a query or series of queries
(my VBA expeirience is very low) that will distribute
work assignments by creating child records in another
table based on the two parent tables
Parents: -Work (records of customer transactions)
- Employees (records of available employees that perform
the necessary job function.
I must use logic to match employees to transaction type
based on.
A) what types of transactions each employee can process
B) The amount of volume each employee can handle [(based
on employee level) taking into consideration that ALL
transaction types will have to be tracked together]
C) making sure that there is even distribution of "work"
across all employees regardless of transaction type.
(my VBA expeirience is very low) that will distribute
work assignments by creating child records in another
table based on the two parent tables
Parents: -Work (records of customer transactions)
- Employees (records of available employees that perform
the necessary job function.
I must use logic to match employees to transaction type
based on.
A) what types of transactions each employee can process
B) The amount of volume each employee can handle [(based
on employee level) taking into consideration that ALL
transaction types will have to be tracked together]
C) making sure that there is even distribution of "work"
across all employees regardless of transaction type.