I have an application that creates an EAN code (13 digit code of which the first 7 numbers are a purchased license and static, the next 5 assigned by the app, and the last digit is a check digit using the EAN ISO approved check digit algorithm).
I am struggling as to how to get this to work. I can create a 12 digit number, but the algorithim requires multiplication on each digit individually, followed by adding the sums, then subtracting from the next "10" (i.e. subtract 54 from 60 or 104 from 110).
The only way I have been able to concieve doing this is to take the numerals, convert to text, break them up into individual fields, reconvert to numbers, do the arithmatic manipulations, then reconstitute the individual numbers back to a 13 digit text field (it needs to be text in the end for other reasons related to another linked database used for reporting.
This seems like a lot of effort, does anyone know of a better simpler way to do something like this??
I am struggling as to how to get this to work. I can create a 12 digit number, but the algorithim requires multiplication on each digit individually, followed by adding the sums, then subtracting from the next "10" (i.e. subtract 54 from 60 or 104 from 110).
The only way I have been able to concieve doing this is to take the numerals, convert to text, break them up into individual fields, reconvert to numbers, do the arithmatic manipulations, then reconstitute the individual numbers back to a 13 digit text field (it needs to be text in the end for other reasons related to another linked database used for reporting.
This seems like a lot of effort, does anyone know of a better simpler way to do something like this??
