Replace #ERROR with Text

[spectraflame]

I have a simple count formula "=Count([WOType])" that counts the number of records found on the report. Currently if there are no records present, the result is #ERROR. I would like to replace the #ERROR with "No Records Found".

I tried this thinking that a similiar Excel technique would work, but of course it does not. Would it look something like this?

=IF(ISERROR(Count([WOType]),"No Records Found",Count([WOType])))

Matthew

 

[alpinescott]

hey, this might work? copy and paste returned values using paste special "values" into a new column, select column and use edit-replace.
Find: #ERROR
Replace with: No Records Found

s

 

[Joe4]

alpinescott,

I think you provided an Excel solution, and the OP is looking for an Access solution. Here is a formula that will work on the Access report:

=IIf(IsNumeric([WOType]),Count([WOType]),"No records found")

 

[spectraflame]

jmiskey,

Thanks a bunch. That will work great.

Matthew