Average query

[cornishteeth]

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

 

[PaulF]

Hi

In the footage field try <>0 in the criteria.

 

[cornishteeth]

Thanks. I was putting <>0 in the wrong place. Much appreciated.

Cornish Teeth