RE: MOD 7

2001-01-12 Thread Adrian Cesana
Just answering my on question...this did the trick... -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] I have 2 blocks of numbers, the first block contains 9 digits the second 8 digits where the last digit in each block needs to be a MOD 7 check digit. I need to

MOD 7

2001-01-12 Thread Adrian Cesana
I have 2 blocks of numbers, the first block contains 9 digits the second 8 digits where the last digit in each block needs to be a MOD 7 check digit. I need to use these numbers in my Primary Key when adding new records, I can easily get the MAX number + 1 but no idea how to get the last MOD 7