M
mattc66 via AccessMonster.com
I need to assign a customer code for 5000 records. The customer code would be
as follows:
The number 2 followed by the first 3 letters of the business name, then 3
digits trailing that start with 100 and incrumenting by 10.
Example:
2AAA100 AAA Steam Repair LLC
2AAA110 AA Alpha Inc
2BOB100 Bobs Place LLC
2WCS100 W&C Supply Inc
As you can see I have some challenges with Space and Characters. As well as
if the first 3 letters match then to increment the number up by 10's. The
customer code would then be added to a fld.
How would I formulate a function to handle this task?
Thanks
Matt
as follows:
The number 2 followed by the first 3 letters of the business name, then 3
digits trailing that start with 100 and incrumenting by 10.
Example:
2AAA100 AAA Steam Repair LLC
2AAA110 AA Alpha Inc
2BOB100 Bobs Place LLC
2WCS100 W&C Supply Inc
As you can see I have some challenges with Space and Characters. As well as
if the first 3 letters match then to increment the number up by 10's. The
customer code would then be added to a fld.
How would I formulate a function to handle this task?
Thanks
Matt