Multiple Select queries as control source in one form

I am trying to create a form which uses multiple queries as its control source. This is so i can calculate averages and counts etc in text boxes on the page. The problem being i have two queries one for left and one for right accuracy's. I have tried the code below but this keeps showing the #Error in the text box

1st Text Box, using the Left Query Accuracy field

=Avg([Left]![Accuracy])/9*100

2nd Text Box, using the Right Query Accuracy field

=Avg([Right]![Accuracy])/9*100

The need for two queries is due to all the data about accuracy is in one Table.

Any help would be greatly appreciated

Thanks