I am querying on a query. The first query is taking out bad data (and replacing it with NULL). The second query is using the TOTALS function, and I am trying to use the AVG of the field. The query says the field is no longer a value field ("DATA TYPE MISMATCH IN CRITERIA EXPRESSION").
The...