Query Criteria and Averages

[Kozbot]

Hello. I am designing queries to return averages for quality test data.

I have this query that functions as I want it too
http://i.imgur.com/K0f7ZLD.png
It returns the averages of all the values received for different tests for a lot number (the lot number criteria should be filled out as well)

When I want the query to be more specific and average only certain box numbers in the lot (that start with the prefix PB") the query does not return an average for box numbers starting with PB but splits them up, showing an average for PB1, PB2 instead of combining the data for those boxes into a single unified average
http://i.imgur.com/cNOGh4t.png

What am I doing wrong here?

 

[plog]

You are Grouping by Box number. In that last field, change the 'Group By' to 'Where'. I'd also change all the others that use criteria to that as well (LotNumber & Reject)

 

[Kozbot]

You are Grouping by Box number. In that last field, change the 'Group By' to 'Where'. I'd also change all the others that use criteria to that as well (LotNumber & Reject)

okay wow, WHY DIDNT ANYONE TELL ME THIS BEFORE.

thank you!

 

[plog]

Uh oh, I just checked with the Access Illuminati and I wasn't even suppose to tell you now. Please, disregard what I said.