My database is an analysis of survey results. The results are included in text strings from which values must be extracted. Responses may be extractable values, text string w/no value or null.
Query 1 - uses nested IIF functions to handle the nulls and text strings with no values and returns the value contained in the text strings
Query 2 - applies a true/false rule to Query 1 in order to distinguish replies in the top 2 of 10 values
Query 3 - feeds my report and averages different questions in Query 2 across differing dates or other divisions
The problem I have is when I get to my report I want to summarize a true average of all responses regardless of the grouping in the detail above but I keep averaging the averages instead of the full dataset. I'm a novice and would appreciate a push in the right direction. In advance, thanks.