Access97 Reports - #num! Error

[AllyF]

I have calculated fields within an access report. One field is divided by another. In some of the output I get the #num! error. There's seems to be nothing in common about the fields with errors. My calculation is :
=IIF((field2)=0,0,(field1/field2)*1000)). Help!!

 

[Trendsetter]

It's possible you are getting a "divide by zero" error - it looks as though the IIF statement you use is to eliminate this type of error, but it could be occuring somewhere prior to this.

 

[koresnordic]

Silly question time. I take it that both field1 and field2 are definatly numbers and do not contain any text or even a blank space.

Graham

 

[MrMcFestoe]

Do both fields have data in them ?

I had this on a report with 27 fields and only one was empty.

Cant you use the Null option to return reports even if there are blank fields

 

[JimInKS]

If field2 is numeric could it also be null, ie never set to anything? If so then I think this will work:

=IIF((nz(field2))=0,0,(field1/field2)*1000)).