Error in query return !

[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 ;-)

 

[abig99]

try using the NoData [event procedure], its in your reports properties section. You may use this to tell your report what to display if there is no data, or even to shut the report.