can't update all the records-PROBLEM

[cervantes008]

I am trying to update a number field with [column1] /
([column1]-[column2]) and I keep getting the "can't update all the
records" Error message.

When I have only "[column1]-[column2]," it works fine, but once I
divide I get the error.

Can anyone help out? Is there a way around this?

 

[NthDegree via AccessMonster.com]

I am trying to update a number field with [column1] /
([column1]-[column2]) and I keep getting the "can't update all the
records" Error message.

When I have only "[column1]-[column2]," it works fine, but once I
divide I get the error.

Can anyone help out? Is there a way around this?

Is it possible that [column1] - [column2] is ever zero? Can't divide by zero.

Try this:

iif([column1] - [column2] = 0,0,[column1] / [column1]-[column2])