mrabrams2
Registered User.
- Local time
- Today, 09:38
- Joined
- Apr 29, 2003
- Messages
- 54
I would like to figure the average without including the zeros.
I'm not a great mathematician, so using a calculator, the Average for the above would be 41 divided by 7 = 5.857...
The SQL is :
Avg(tbl_ABC.MyCount) AS AvgOfMyCount
What syntax do I use if I want my result to ignore the zeros?
41 divided by 5 = 8.2
Your help is always appreciated.
Michael
Code:
REC# MyCOUNT
1 0
2 5
3 12
4 0
5 3
6 5
7 16
I'm not a great mathematician, so using a calculator, the Average for the above would be 41 divided by 7 = 5.857...
The SQL is :
Avg(tbl_ABC.MyCount) AS AvgOfMyCount
What syntax do I use if I want my result to ignore the zeros?
41 divided by 5 = 8.2
Your help is always appreciated.
Michael