PERCENTAGE score if value>0

[max20]

hello everyone, i d would like to know how to HAVE THE TOTAL SCORE IF:
id1 from table A SCORE= 20%
id2 from table A score=10%
ID3 from table A score=0%


TOTAL: score ( ID1+ID2+ID3) from table A =10%
What i need to know is how to not count id3 because the score =0
so SCORE( ID1+ID2=ID3) ÷2=15%


AND REPORT THE SCORE IN A FORM

THANKS

[alansidman]

1. Be sure that your data is normalized
2. Use the group by function in a query
3. Use the Avg function within the Group by functionality
4. Make the query the record source for the Form

https://www.techonthenet.com/access/...umeric/avg.php

[Micron]

...and the criteria like WHERE [table A].[ID3]<> 0?
(assuming the field is numeric and not text)

Pretty sure the avg function includes zeros as data points, but not Nulls. I'm no mathematician, but I've been told that sometimes, calculating the average of averages is not a good idea. That's what this looks like, but it might also be an average of ratios. Then I'm clueless