Average of days task was open
I have a situation where I have two tables,
1- tasks
2- vendors
There is a one to many relationship where each vendor may have many task.
In the tasks form I have a field that calculates days it took to complete that task. (numeric) how do I pull that information into the vendors report, so that an average of how long it took the vendor to complete his assigned tasks will appear.
1- tasks
2- vendors
There is a one to many relationship where each vendor may have many task.
In the tasks form I have a field that calculates days it took to complete that task. (numeric) how do I pull that information into the vendors report, so that an average of how long it took the vendor to complete his assigned tasks will appear.
