Average Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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