can't update all the records-PROBLEM

  • Thread starter Thread starter cervantes008
  • Start date Start date
C

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?
 
cervantes008 said:
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?
Click to expand...

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

Try this:

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