Average Problem

F

Frank

I know this is probably easy, but cant seem to figure it out. I am attempting to take and average of a field I created([FOOTAGE]). Some of the fields entries contain a zero in the amount and its messing up the average. For example, I have a parameter query that asks for a date range. I inputted a range total of 8 days(01/01/04 to 01/08/04). There are only 5 entries in the FOOTAGE field in that date range and three contain 0 values. What is happening is that it takes the total amount of FOOTAGE and divides by 8 vice 5. How do I fix this in the query to where it skips the zero values

Thanks for the help

Frank
 

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 interpurchase times 5
countifs Function not giving desired result with date criteria 2
Running average - subquery? 4
Group By, Max & Last 2
0(Zero) in query 2
How to find the difference between values of multiple records 12
Looking up across date ranges in Access 2
Average problem 1

Top