# How to make Index on record???

Posted by Shih Yao on August 10, 1998 at 13:51:04:

Someone can help me??? My problems is like: -

I have created a label called "lblIndexDisplay" and I want computer will generate index number to each record(I have created a
database with Microsoft Access)on "lblIndexDisplay".....

The Index Number for generate automatically will according to Country(3 Country I have created....CHINA, HONG KONG, TAIWAN)
. For example, China record with Index No. beginning with CHI001, Hong Kong record with Index No. beginning with HK001 and
Taiwan record with Index No. beginning with TW001.... So, How I coding with this situation???
I hope somebody can help me!!! I dun't know how to code this situation.....Please help me.... Thank you!!!

* I'm very sorry about inconvenience for everyone becoz I'm wrote in English... I just can view Chinese word with MagicWin....
Sorry to all!!!

Follow Ups:

- Re: How to make Index on record??? David Wong 15:20:02 8/10/98 (0)