M
Mavis
Hi,
I have this table with all the claims are recorded in this table with a
form. I need to Custom my claim number (primary number) to certain format
(yynnnnn). YY will be the last 2 numbers of the year, nnnnn will be the
running number. The claim number will look something like this "0900001".
The running should be restart every new year.
When i create query and run a report, this claim number should show in the
report. Which mean that this number should be in the table.
Can anyone advice me how can i do that? i am new with Access 2007.
I have this table with all the claims are recorded in this table with a
form. I need to Custom my claim number (primary number) to certain format
(yynnnnn). YY will be the last 2 numbers of the year, nnnnn will be the
running number. The claim number will look something like this "0900001".
The running should be restart every new year.
When i create query and run a report, this claim number should show in the
report. Which mean that this number should be in the table.
Can anyone advice me how can i do that? i am new with Access 2007.