Creating An Average From Specific Records In Multiple Tables?

[jsbatal]

How can I create a calculated field that takes a number from the most recent record entered on three tables and averages them? I guess it'll be a mix of queries and calculated fields, but I'm not sure exactly how to do it.



The use case is basically a table to keep track of computer systems, and three tables that contain different kinds of assessments for those systems (business, technical, and operational) Each of those assessments will have a score between 1 and 5, and I'm trying to generate a field on the System object to average those three scores into an overall current (i.e. 3 most recent assessments for each system) system score. Any ideas?

[ranman256]

Build a query to pull the data you want to count, Q1.
then Q2, calculates the AVG from Q1:

select AVG(field) from Q1