How to count and do averages

  • Thread starter Thread starter Sharp
  • Start date Start date
S

Sharp

Hi

Consider the table:

tblExample
PrimaryKey_FieldOne FieldTwo
1223 120
2232 220
3233 450
4233 550
5233 660

How to count the number of rows that have data in FieldTwo greater than
average?
So, first i want to find the average of the data in FieldTwo,
then count the number of rows that have a FieldTwo greater than the
calculated average.

Tried:
SELECT *
FROM tblExample
WHERE COUNT(FieldTwo > AVERAGE(FieldTwo));

Any help appreciated.

Cheers
Michael
 
I think this will work:

SELECT Count(*) AS NumRecordsGTAverage
FROM tblExample
WHERE (((tblExample.FieldTwo)>(SELECT Avg(tblExample.FieldTwo)
AS AvgOfFieldTwo FROM tblExample)));


Tom
__________________________________

Hi

Consider the table:

tblExample
PrimaryKey_FieldOne FieldTwo
1223 120
2232 220
3233 450
4233 550
5233 660

How to count the number of rows that have data in FieldTwo greater than
average?
So, first i want to find the average of the data in FieldTwo,
then count the number of rows that have a FieldTwo greater than the
calculated average.

Tried:
SELECT *
FROM tblExample
WHERE COUNT(FieldTwo > AVERAGE(FieldTwo));

Any help appreciated.

Cheers
Michael
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Calculation when zeroes are present 6
I can't change count to average in pivot table data 1
Average/Sum formula with offset 5
average formula 2
Averaging with IFs 2
Excel Excel: average range of cells including zeros and excluding blank across sheets 0
I would like to average the last 4 entries each time i add one 0
Sum, Average, and Count from imported .txt file 2

Back
Top