Ok guys..Any help would be great.. What i'm trying to accomplish here
is. Creating a function and/or formula in Excell or access that will
calculate the check digit value of a 20 digit number. I have seen
several sites that have VB code on how to do..however I do not know how
to incorporate vb code into a Ms Access db and make it do my requested
task...

ie... http://www.makebarcode.com/info/appnote/app_003.html
http://www.excelbanter.com/q-t_19172...eck-Digit.html
http://www.freevbcode.com/ShowCode.Asp?ID=1035

ie... I have a field "barcodewithnocheckdigit" and an example value
for that field is "8260212616630008000" The check digit sum for that
figure is 9. I have 40,000 records. Is it possible to have this
code/query calculate and update the check digit value field?

The instructions on calculating a check digit value are here :

http://tinyurl.com/joqy


So I guess my question should be "how do I use this code in my
database" Please keep in mind that I have no programming knowledge
whatsoever...therefore I need step by step information pretty much..

Thank in advance for your help.


--
tnelson