troubleshooting Question

MS Access or Excel "check digit fomula"

Avatar of tnelsonx2x
tnelsonx2x asked on
Databases
28 Comments1 Solution3066 ViewsLast Modified:
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-Mod-10-Check-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://www.uc-council.org/ean_ucc_system/education_support/cdc.html#SSCC


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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 28 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 28 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros