Hi,
I posted the following in the SQL forum but would also consider doing this in access.
I am trying to generate a check sum from a number such as 2300282697345. I can do this in excell but have not found a way to do it in SQL. How I do this in excell is take the number from the first worksheet and in a second worksheet I take the first number as it is(2), take the second number * 2 (3*2), take the third number (0), take the fourth number *2 (0*2) etc
Then in a new worksheet I take the first number of the secondsheet if it is greater than 9 I subtract 9 from that number, take the second number as it is, take the third number and if it is greater than 9 subtract 9 from that value, take the fourth number as it is, etc. I then sum all the numbers together and take the first number to the right for the checksum. Using the number above, I get a value of 56 so the check sum would be 6.
Please help. Thanks
I posted the following in the SQL forum but would also consider doing this in access.
I am trying to generate a check sum from a number such as 2300282697345. I can do this in excell but have not found a way to do it in SQL. How I do this in excell is take the number from the first worksheet and in a second worksheet I take the first number as it is(2), take the second number * 2 (3*2), take the third number (0), take the fourth number *2 (0*2) etc
Then in a new worksheet I take the first number of the secondsheet if it is greater than 9 I subtract 9 from that number, take the second number as it is, take the third number and if it is greater than 9 subtract 9 from that value, take the fourth number as it is, etc. I then sum all the numbers together and take the first number to the right for the checksum. Using the number above, I get a value of 56 so the check sum would be 6.
Please help. Thanks