Calculating the Total of Average Fields

[DDEB]

I'm running a query to find the average of data in 5 columns. Example column 1: AVGWest: Avg([Evaluation]![BC]+[Evaluation]![Alberta]+[Evaluation]![Saskatchewan]).



I'm now trying to find the total of the 5 average columns. Everytime I run the query with a total column I'm given a parameter prompt with titles the same as the original parameter query. Example: Enter Parameter Value: AVGWest.

Any help would be appreciated on how to find this total correctly so I don't receive the prompt.


Thanks!

[June7]

Show the query SQL for analysis.