Query Average

[Jim via AccessMonster.com]

Access 2003 query and using the View Totals, I choose average, the default
field is $0.00, and I want to average fields that are not zero values, I
looked at a lot of posts and tried some but, don't really understand what
their doing. I need the average for dollars entered. Do I need to do SQL
statements or is there something I can put in the criteria field in the query?

 

[John Vinson]

Access 2003 query and using the View Totals, I choose average, the default
field is $0.00, and I want to average fields that are not zero values, I
looked at a lot of posts and tried some but, don't really understand what
their doing. I need the average for dollars entered. Do I need to do SQL
statements or is there something I can put in the criteria field in the query?

If you simply want to exclude zero values, use a criterion. In your
Totals query select the field name TWICE; on the totals row under one
instance select WHERE, and under the other instance select Avg.

On the Criteria line under the WHERE column, put

<> 0

to select only nonzero values (or ? 0 to select only positive ones).
i
John W. Vinson[MVP]