By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 854 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Sequential number

P: n/a
I need to have a field to generate the report number with the following
format:-

The first part consists of four digits for each year. It could be obtained
from the date field entered manually.

The second part consists of four digits for the report number of the year.
It should be generated automatically when a record is created. The number
must be incremented by 1 for each new record and not repeated in the year
but can be repeated each year.

The third part consists of a single digit for each part of report number,
ie, -1, -2, -3. It should be generated automatically when a record is
created. The number must be incremented by 1 for each new record and not be
repeated in a report number but can be repeated in other report numbers.

Can someone share the experience in generate such report no for reference.

Thanks,

Scott


Apr 17 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.