AnsweredAssumed Answered

How do I calculate based on different fields in two different related records?

Question asked by JodiGronborg on Sep 12, 2013
Latest reply on Sep 13, 2013 by philmodjunk

Title

How do I calculate based on different fields in two different related records?

Post

     Greetings! So I have a table with measurements on frog calls, and a related table of notes measurements. Each call has two or more notes. I need to calculate internote intervals. So in the call layout I want a calculation fieldd that will look at notes for that call and...subtract the value in the 'end time' field for the second to last note (note for which 'unit category' field contains "2l") from the value in the 'begin time' field for the last note (unit category = "ln").  Help!

Outcomes