Is there a count of records formula? 1

[deb18]

I would like to have a text field that prints if the query returns no records.
Is there a way to test for this?
If I use the count function it returns 1 if there is 1 record but if there are no records it doesn't seem to return anything.

 

[lbass]

You should be able to use a formula like:

if isnull({table.ID}) then "No Records" else ""

where {table.ID} is a field which appears with each record.

-LB

 

[deb18]

That worked great. Thank you!