Skip to main content
Question

Average of days task was open

  • July 20, 2017
  • 0 replies
  • 15 views

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.
This topic has been closed for replies.

  • Author
  • Registered
  • July 21, 2017
You'll need to build a Summary Field from within the relationship between the tables. When you open up the relationship, select the Add Summary Field button at the bottom left and it will walk you through the steps.

  • Author
  • Registered
  • July 27, 2017
thanks, that worked!