Re: Reset a number back to 1 at the beginning of the year
- From: Tim Ferguson <FergusonTG@xxxxxxxxxxxx>
- Date: Tue, 13 Dec 2005 09:48:13 -0800
"=?Utf-8?B?Ym9iZWM=?=" <bobec@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:36E4CAB1-2272-4CB7-9FED-B78BB04F9BD7@xxxxxxxxxxxxx:
> I have a project I am working on where the client requires a document
> number to increment by 1 each time and the prefix of the number is the
> year (ex. 05-00001, 05-00002, etc.) I need to program the number on
> the form to roll back to "06-00001" at the beginning of next year (And
> subsequent years).
You need two columns: YearNumber and SerialNumber. It's then a trivial
business to use a DMax() call to find the largest number allocated for the
particular year. It's even easiser to contatenate the fields on forms and
reports. Google for "Access Custom Autonumbers" for more details.
Tim F
.
- Prev by Date: parameters/drop down
- Next by Date: Re: parameters/drop down
- Previous by thread: parameters/drop down
- Next by thread: Re: Reset a number back to 1 at the beginning of the year
- Index(es):
Relevant Pages
|
