Averaging with a blank field

[Gabriel2012]

Hello all, so here is my predicament; I am calculating an avg, in a query, based on two fields "CountofErrors" / "OrdersAudited". The issue I am running into is that on certain dates specific teams will have no errors, so the "CountofErrors" is simply blank, and not a zero, so no percentage calculates. I need to calculate a 0% value in this field, how would I go about doing that?



Thank you!

[ssanfu]

Is it Blank or NULL??
You could try the function NZ() (see help)

Something like:

NZ([CountofErrors],0)

[Gabriel2012]

I assume it is Blank, every date has an audit but everydate does not have an error, I have a one way join which forces the date and amount of audits to show even if no errors were recorded for that date, so the count of error field would simply be blank. Unless I am missing something?

[ssanfu]

Could be Blank, Empty or NULL. They are not the same thing. If there is nothing in the control, I would thing it is a NULL value