can't update [column1] /([column1]-[column2])

[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?

 

[KeithG]

Are any of the values Null values? If so you can use the NZ function.

 

[cervantes008]

I am trying to update through a query. I am having a hard time finding a way to NZ my little update criteria. Do you have any examples on how to NZ'ing a divide by zero?

 

[KeithG]

Nz([Column1],0) this should work

 

[cervantes008]

[column1] /([column1]-[column2])

I've tried all the combinations.

nz([column1],0) /([column1]-[column2])

[column1] /(nz([column1],0)-[column2])

[column1] /([column1]-(nz([column2],0)

nz([column1] /([column1]-[column2]),0)

and nothing worked.

The only number that could possibly be null or 0 is column 2's value.

 

[KeithG]

Nz([column1],0) /(Nz([column1],0)-nz([column2],0))

try the above

 

[cervantes008]

That worked!!!

Thanks a bunch Keith