Returning a zero if no records found

[system]

The duplicated post is here:

120×120 10.4 KB

Hello, i’m running some queries for a report, and counting the records retrieved from the queries. For some of the queries, i’m expecting zero records; whenever i refresh data i get the message that “No records retrieved for xxx” and then when i want to show the count on a report, the cell is empty. I want to avoid this message and show zero (instead of empty). Can anyone help me with this? Thanks. monty_mm (BOB member since 2007-11-22)

Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

Topic locked.

---

Marek Chladny (BOB member since 2003-11-27)