Microsoft Access Error Codes

[Lonesome Kicker]

When using Excel, I have used the Iserr function to remove error codes frommy spreadsheet. Now I am in access and I have a calculation that sometimes divides by zero. This returns a #error value. In excel I use the following if(iserr(varA/varB)="True",0,varA/varB). Is there a similar method in Access?

 

[CT Witter]

Try this:

Avoiding dividing by zero:

=IIf([Divisor]=0,"",[Dividend]/[Divisor])

HTH,
CT

 

[Corticus]

Just to add to CT Witter,

You can specify something to be null in Access, like:
=IIf([Divisor]=0,Null,[Dividend]/[Divisor])

"" is a zero-length charachter and can sometimes create problems, especially when appending data into a table.

 

[Lonesome Kicker]

Thanks!