#error in Access

I am running a report that attempts to manipulate data produced by a query. When the query does not return any data, my report fileds that perform calculations show #Error. Is there a way to supress that result so that either nothing comes up or the fields show blank? Thank you.
Answer
Answer

You'll get an error if you try to reference a control on a subform without any records.  Try the IsError function:

IIf(IsError([MyField]),0,[MyField]).

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 19, 2024 Views 7,335 Applies to: