#error ????

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

In a report I have this syntax which calculates the total Net Profit
If the value IsNull (no Data) then it gives me the #error in the field
How can I eliminate this? (Currency Format)

=Sum([NetAfterCom])-[Reports]![RProfitLoss]![RProfitLossSub].[Report]![SumOftxtRate]
 
Dave,

The value is not Null. It is non-existent.

Try it like this...

=Sum([NetAfterCom])-IIf([RProfitLossSub].Report.HasData,[RProfitLossSub]![SumOftxtRate],0)
 
Try this:
=Nz(Sum([NetAfterCom]),0) - IIf([RProfitLossSub].[Report].HasData,
Nz([RProfitLossSub].[Report]![SumOftxtRate],0), 0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with an expression to calculate a profit from one of three fi 2
Sum Calculated Field Question 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Correct syntax for referencing a form control???? 2
truncating values in sum on report 4
Excel Excel 2007 won't stop rounding down my formula results! 5
Access Access Report Works on One Machine but not Another 3
Can't create a report from my query in Access 1

Back
Top