How do I create an autonumber command for Access 97 that creates a sequential number following the following format:

p00/nn. where 00 is the year created?

I'm using the RND() command at the moment in the following construct:

="p" YEAR(NOW())"/"rnd(1-99)

Which returns a value of P2000/nn.

So I would like to condense the YEAR(NOW()) to return only the last two digits of the year.

Also the rnd statement returns a random number between 1 and 99, which is fine for my purposes, but it would be better if it could be made to return the next unused number in the sequence.

Any ideas?

Thanks

------------------
Ron Heywood