#NUM! Replacement

[ECEK]

I have a form where the undelying query1 shows my customers and I have linked another query2 to show other data however where there is no data to show in Query2 it comes up with #NUM!

I will add that the Query2 is a calculation where there is no result it shows #NUM!

How do I get rid of this?

 

[pr2-eugin]

Could you please show us the query?

 

[ECEK]

Im afarid the query is rather complex and references too many external tables in order to illustrate the issue here. I just assumed that there was a simple: If there is an error in the cal then show null if not show calculation !!

I've managed to get round the problem by creating an IIf scenario on some underlying calculations, however it is irritating that you can't simply put an If Error formula in.

 

[ECEK]

I've figured out my own problem. I had set criteria to only show certain data in my query and sure enough found that there were calculations that were creating an error.