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!