Creating a report that shows Averages for 3 different tables.
I'm trying to create a report that shows the averages of 3 different tables on one report. I have 3 tables:
They are all related by the clientID field
For each one of these tables, I created a summary field that shows the average weight. The problem is when I create a report, Only one average result (initial screening average weight) is displaying on the report. When I add the other two average fields to the report, the report isn't showing the second and third screening average weights.