Question How to Average certain data in a Query

[shieriel]

How can i make an average for a certain record that only when a data for an item reaches 30 then the query will give an average. I already created a query that shows what are the items from my table that has 30 data records. I just dont know how to create an average data per item that reaches 30 records.

 

[John Big Booty]

Check the options you get in your query when you click the Totals Σ Button. You should find that one of the options is Average.

 

[shieriel]

Check the options you get in your query when you click the Totals Σ Button. You should find that one of the options is Average.

Thank you sir, i almost forgot that command

 

[shieriel]

Check the options you get in your query when you click the Totals Σ Button. You should find that one of the options is Average.

Sir John. I tried to apply "Average" on my data but since i have so many product not just one, maybe the access got confused because i got an error when i applied .
On my database we have more than 1k different products and each product having about 10 parameters. What i want on my database is to monitor each product that ran on our machine and monitor the different parameters applied per product during its running period on the machine.
Example, for product #1 what are the average data per parameter1 to parameter10 when the data reaches 30 and above. And out of the 1k products the query will exclude all products where the parameter data is less than 30.
Sounds complicated for me and i still cannot get the right formula for this. Hope you can help me...