AnsweredAssumed Answered

Creating a report that shows Averages for 3 different tables.

Question asked by cmac on Dec 2, 2010
Latest reply on Dec 2, 2010 by philmodjunk

Title

Creating a report that shows Averages for 3 different tables.

Post

I'm trying to create a report that shows the averages of 3 different tables on one report.  I have 3 tables:

Initial Screening

Second Screening

Third Screening

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. 

Any suggestions???

Outcomes