Evaluating the expression DCOUNT

[MusicMogul]

Hey Everyone,


I'm trying to evaluate the DCOUNT expression. If there were no values found, it gives a "#Error" in my report. That "#Error" message doesn't look good on a report.

How can I allow show "NO values were found " text instead of "#Error"message ?
I tried the following expression but it won't work

=IIf(IsNull(DCo unt("ValueID";[RecordSource];"(" & [Filter] & ") AND (ReportNotAvail able=true)")) ,"No Values were found"', ""). I keeping the that the expression is not valid.

MusicMogul

[Rabbit]

Have you tried IsError()?

[MMcCarthy]

Try this ...

 
=NZ(DCount("ValueID";[RecordSource];"(" & [Filter] & ") AND (ReportNotAvailable=true)"),"No Values were found")