Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

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

    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?

  2. #2
    Join Date
    Sep 2003
    You're trying to update ... Using which method?

    Did you by any chance happen to notice your suseptibility to DIVIDE BY ZERO???? You might want to consider NZ'ing your denominators to prevent that ... And maybe IIF it to ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts