By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

You tried to execute a query that does not include the specified expression

P: 1
I am trying to write a query that will provide the average of 5 columns. Here is my query, but each time I try to run it I get this error:

You tried to execute a query that does not include the specified expression 'Proposal #' as part of aggregate.

Average Rating: Avg([Eval #1 Overall Rating]+[Eval #2 Overall]+[Eval #3 Overall]+[Eval #4 Overall]+[Eval #5 Overall])

My fields are:
proposal #
offeror name
course name
instructor/offeror
eval #5 overal
eval #1 overall rating
eval #2 overall
eval #3 overall
eval #4 overall
evals provided

What am I doing wrong??
Mar 8 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,485
The average function aggregates across records and not across fields.

You need to add the values together and divide by the number of columns (5).
Mar 8 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.