How do i hide #Num! errors in Access 2007?

[JemBlack]

I'm using access 2007. In a report I am getting #Num! errors.
I know it's caused by trying to devide a number by zero. But how do I hide
the error?
I know how to do this in excel but nor access

 

[Carl Rapson]

I'm using access 2007. In a report I am getting #Num! errors.
I know it's caused by trying to devide a number by zero. But how do I hide
the error?
I know how to do this in excel but nor access

I don't think you can hide it, but you can allow for it. Anywhere there's a
possibility of dividing by zero, use an IIf statement:

IIf ([somefield]=0, 0, [someotherfield]/[somefield])

Carl Rapson

 

[Maurice]

You can do the same thing in Access you do in Excel. You can use the ISERROR
function something like if(iserror())

 

[JemBlack]

I'm using access 2007. In a report I am getting #Num! errors.
I know it's caused by trying to devide a number by zero. But how do I hide
the error?
I know how to do this in excel but nor access

I don't think you can hide it, but you can allow for it. Anywhere there's a
possibility of dividing by zero, use an IIf statement:

IIf ([somefield]=0, 0, [someotherfield]/[somefield])

Carl Rapson


Carl,

Thanks for your help. Just so I know i'm doing this right, can you translate
this into the required formula please....

=[CountOfWON DOUBLES?]/[CountOfPLAYED DOUBLES?]

It's set to show as a percentage

Cheers,
Jem

 

[Carl Rapson]

I'm using access 2007. In a report I am getting #Num! errors.
I know it's caused by trying to devide a number by zero. But how do I
hide
the error?
I know how to do this in excel but nor access

I don't think you can hide it, but you can allow for it. Anywhere there's
a
possibility of dividing by zero, use an IIf statement:

IIf ([somefield]=0, 0, [someotherfield]/[somefield])

Carl Rapson


Carl,

Thanks for your help. Just so I know i'm doing this right, can you
translate
this into the required formula please....

=[CountOfWON DOUBLES?]/[CountOfPLAYED DOUBLES?]

It's set to show as a percentage

Cheers,
Jem

=IIf([CountOfPLAYED DOUBLES?]=0, 0, [CountOfWON DOUBLES?]/[CountOfPLAYED
DOUBLES?])

If [CountOfPLAYED DOUBLES] is zero, your percentage should show as 0% (the
middle parameter). You can modify this to show whatever you want there.

Carl Rapson

 

[JemBlack]

THANKS FOR YOUR HELP... WORKED A TREAT.

I'm using access 2007. In a report I am getting #Num! errors.
I know it's caused by trying to devide a number by zero. But how do I
hide
the error?
I know how to do this in excel but nor access

I don't think you can hide it, but you can allow for it. Anywhere there's
a
possibility of dividing by zero, use an IIf statement:

IIf ([somefield]=0, 0, [someotherfield]/[somefield])

Carl Rapson


Carl,

Thanks for your help. Just so I know i'm doing this right, can you
translate
this into the required formula please....

=[CountOfWON DOUBLES?]/[CountOfPLAYED DOUBLES?]

It's set to show as a percentage

Cheers,
Jem

=IIf([CountOfPLAYED DOUBLES?]=0, 0, [CountOfWON DOUBLES?]/[CountOfPLAYED
DOUBLES?])

If [CountOfPLAYED DOUBLES] is zero, your percentage should show as 0% (the
middle parameter). You can modify this to show whatever you want there.

Carl Rapson