Display specific text if report has no results

[ITguy1981]

I have a report based on a duplicate query. If there are no duplicate reults I would like for the reports to say "0 matches Found". Actually, another good idea might just to be have the report count the matches so it says "2 matches found" or "6 matches found" etc. Any idea on how to do this?

 

[vbaInet]

What does the report display at the moment when it has no matches?

=Count(*) & " matches found"

... in the Report's Footer section.

 

[ITguy1981]

That worked perfectly. I was looking at a few count options. I've never used count, dcount, lookup, etc in a report. With no matches I get a result of "0 matches found" now.

 

[ITguy1981]

Thank you.

 

[vbaInet]

You're welcome!