Search results

Thank you very much Mihail. This works perfect. I entered the following: Verify: Left([Table1]![AWBNumber],7) Mod 7=Right([Table1]![AWBNumber],1) commas instead of semicolons before 7 and 1. The Verify results I get are -1 and 0 for true and false respectively.

AWB numbers consist of 8 digits. The rightmost digit is a Mod 7 check digit. For example: 1234567 returns a check digit 5, so the AWB number is 12345675. How do I design a query to validate the accuracy of an AWB number?

Hi Jon, I am a beginner at database programming barely scratching the surface. I am almost done studying Microsoft Access 2010 Step by Step. The help section of Access 2010 directed me to this forum. Thank you for allowing me to join and I hope to learn as much as I can about Access from...