Nil Value

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

Guest

Have created a database to track eroors people are making and reports to
repot thos errors. One of the requirements is if a persons work was checked
on a particular day then we still record how many items were checked but
leave the "Errors Found" field blank in effect to sho that person had a 0%
error rate for that day.

I have created a query using simple count functions, that works fine if
there is an eroor but how can I change the count of Errors Found to report as
a Zero if the person had no erroors. Present it is counting that there is a
record and reporting it as 1 Error found???

Help please,
 
You can use the NZ() function. Replace references to your Errors Found field
with an expression such as: NZ([Errors found], 0). See NZ Function in the
help file for details.

However, a Null value is best used to represent an unknown value, e.g., we
haven't checked this person's work yet, so we don't know whether there were
errors or not. If the work has been checked and there were no errors, it
would be better to enter a 0 in the field.
 
Back
Top