jcarroll3102
New Member
- Joined
- Apr 2, 2005
- Messages
- 5
I am trying to create a database that has a form with customer number, customer name, amount, and date.
I need the loan number to be automatically generated 10 digits. Digits 8 and 9 need to be 12 more than the previous number. The tenth digit needs to be Zero if sum of digits 1-9 are even, five if sum is odd
Ex: 1100012340
1100012465
This is my first Access post, I would appreciate any help you guys could provide
I need the loan number to be automatically generated 10 digits. Digits 8 and 9 need to be 12 more than the previous number. The tenth digit needs to be Zero if sum of digits 1-9 are even, five if sum is odd
Ex: 1100012340
1100012465
This is my first Access post, I would appreciate any help you guys could provide