Custom Claim Number

[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.

 

[BruceM]

This question is being addressed in an earlier thread.