I have a query that I am trying to build, that joins 2 other queries together. There is one field named "Value" and the actual values in that field are populated based on a field named "Name". So in the Name field, I want to pull "Sheet Length*", "Sheet Width" and "Sheet Count" and have the Value for those fields populate in the result, which, I have it working just by setting the criteria. The problem I am running into, is I want to create 3 calculated fields in this query to separate those values, so one calculated field would be the average based on the name "Sheet Length*", one calculated field would be the average based on the name "Sheet Width" and one calculated field would be the average based on the name "Sheet Count". I am not sure what I am doing wrong, but I keep getting a syntax error. Any help would be so greatly appreciated! Thank you!