Return of "Error" in a query

[SKing44]

I hope sombody can help with this.....
My database runs a report which looks for records, counts them and the assigns a value depending on the type of data returned. My problem is that if there are no returned records, my query gives the result of "Error", How do I get a return of "0" or another value from a query if there are no records ?

Thanks ;-)

 

[tomschafer]

Use the nz function. Straight from Help...

You can use the Nz function to return zero, a zero-length string (" &quot, or another specified value when a Variant is Null. For example, you can use this function to convert a Null value to another value and prevent it from propagating through an expression.

Syntax

Nz(variant[, valueifnull])