Hi, I am a newbie to access and leaning the same, I am stuck at a problem as below,
I want apply a customer number based on other criteria as below,
AAA : 0000 : BBB 9999 (without spaces)
where
AAA is our Company Short code (Like MEC, MIC, MTC etc.)
0000 is the serial number for every customer
BBB is the group customer code (Like TIL, RIL, REP etc.)
9999 is the serial number for customer from that particular group
For every group the 0000 remains the same and customer of that particular group 9999 increments
(Eg. MEC:1324:TIL0150, MEC:1324:TIL0200 etc. MEC:1456:RIL2246, MEC:1456:RIL1457)
If a non group customer then 0000 increments and ": BBB 9999" is not added to it ( eg. MEC:1256 )
The fields available are customer Type to find out the type of customer. All the data related to customer details is store in customer details table.
The customer type comes from another table named Customer Type
And I want to increment the serial number and group serial number as accordingly.
I want apply a customer number based on other criteria as below,
AAA : 0000 : BBB 9999 (without spaces)
where
AAA is our Company Short code (Like MEC, MIC, MTC etc.)
0000 is the serial number for every customer
BBB is the group customer code (Like TIL, RIL, REP etc.)
9999 is the serial number for customer from that particular group
For every group the 0000 remains the same and customer of that particular group 9999 increments
(Eg. MEC:1324:TIL0150, MEC:1324:TIL0200 etc. MEC:1456:RIL2246, MEC:1456:RIL1457)
If a non group customer then 0000 increments and ": BBB 9999" is not added to it ( eg. MEC:1256 )
The fields available are customer Type to find out the type of customer. All the data related to customer details is store in customer details table.
The customer type comes from another table named Customer Type
And I want to increment the serial number and group serial number as accordingly.
