verify keyed total on form

  • Thread starter Thread starter TomC
  • Start date Start date
T

TomC

Eight dollar values are reported on a registration form plus a total dollar
value. After the total dollar value is keyed, I would like to be able to sum
the eight values and compare that sum to the keyed total dollar value and
deny acceptance of the form if there is a difference. If that is possible,
what is the approach I would use to do that?
Thanks in advance. Tomc
 
Tom,
Why sould anyone have to "enter" the total of all 8 fields?
Why aren't you just calculating that value?

=NZ(Field1) + NZ(Field2)..... thru to.... NZ(Field7) + NZ(Field8)
would yield the total of all 8 fields.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
The total value is the money they have submitted in a check for the
occurrences in the other eight totals. I just want to verify that they made
no mistakes in the money they have forwarded. Thanks. tomc
 
Back
Top