Results 1 to 3 of 3

Thread: Newbie Question

  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Newbie Question

    Probably being a bit thick her but can't see the wood for the trees with this one..

    I've got a table with 10 seperate percentages (it' a production recipe) and when a new record is added I need to verify that the total of these fields adds up to 100 before it can be saved.

    Any help/suggestions greatly appreciated.

  2. #2
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107

    Re: Newbie Question

    Originally posted by bigred
    Probably being a bit thick her but can't see the wood for the trees with this one..

    I've got a table with 10 seperate percentages (it' a production recipe) and when a new record is added I need to verify that the total of these fields adds up to 100 before it can be saved.

    Any help/suggestions greatly appreciated.
    try using the valdidation rule of the table properties

    cheers
    bachatero

  3. #3
    Join Date
    Mar 2004
    Posts
    3

    Re: Newbie Question

    Originally posted by bachatero
    try using the valdidation rule of the table properties

    cheers
    bachatero

    bachatero

    I was right - I was being thick.

    Cheers for the reply. Sorted.

    Jonny

Posting Permissions

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