Results 1 to 2 of 2

Thread: sum question

  1. #1
    Join Date
    May 2004

    Unanswered: sum question

    i have three feilds: new, two,three. now i want to add these feilds and make sure they = my total feild. So i would want a error message if those feilds dont equal my total feild and if they do a msg box saying they do. I would run this script from a button, ANy suggestions or help

  2. #2
    Join Date
    Jul 2004
    Blackburn, UK
    Dim Sum as double

    Sum = New + two + three

    if not sum = totalfld then
    msgbox "Please not field do not equal total field", vbinformation,"Not equal"
    msgbox "Sum equal", vbinformation,"Equal"

    end if

    exit sub

    Hope that helps

Posting Permissions

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