Query Average

  • Thread starter Jim via AccessMonster.com
  • Start date
J

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?
 
J

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?
Click to expand...

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]
 
Top