• Validation ? (Access 2000)

    Author
    Topic
    #440194

    i want to forbid the figues in my tables to be less than 0. For example if there is a substraction 1 – 2 the result should not be -1 but instead a message that something is wrong. How can i achieve that? Shal i use the validation Rule in the table ?

    Viewing 0 reply threads
    Author
    Replies
    • #1053925

      Open the table in design view.
      Click in a field.
      Click in the Validation Rule box.
      Enter >=0 Or Is Null
      Click in the Validation Message box.
      Type a warning, for example Negative values not allowed
      Repeat for the other fields that should not be negative.

      Note: tables do not contain calculated fields. Queries can have calculated fields, and forms can have calculated controls.

    Viewing 0 reply threads
    Reply To: Validation ? (Access 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: