Discussions

 View Only
  • 1.  Average of days task was open

    Posted 07-20-2017 18:12
    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.


  • 2.  RE: Average of days task was open

    Posted 07-21-2017 16:32
    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.


  • 3.  RE: Average of days task was open

    Posted 07-27-2017 15:11
    thanks, that worked!