3 Replies Latest reply on Aug 20, 2009 9:29 AM by lshrdn

    Tables: Need to have Text Box Message appear if Totals don't agree

    lshrdn Level 1

      I have a table that has six columns of numbers. Each column is totaled. I would like to get an text box ("These totals must agree") to appear IF (Column Mice + Column Rats) is NOT equal to (Column B + Column C + Column D + Column E.)

       

      I do not need to sum the totals of any of the columns, that is to say, I do not need to know the total of mice plus rats, etc. I just to make sure that the numbers of rats and mice are equal to the number of category B, C, D and E animals. And to let the form user know it.

       

      Hope this makes sense!

       

      Thanks!