AUTONUMBER

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

USE AUTONUMBER IN A CUSTOMISED NUMBER STRING WHICH WILL RESET BACK TO 1 AT
THE START OF A NEW YEAR. EG ABC/462/2006 CHANGES
TO ABC/1/2007 AT TURN OF YEAR
 
if yuour previous codes had been working fine, the olny thing that you need
to do is:
go in your table and put the ABC/1/2007

if you had the correct code it will string and will work fine..

please reply if you have still the problem.

Thanks
 
you can't use the Autonumber data type for this. conventional wisdom says
that it's better to *not* concatenate meaningful values into a single field.
instead, store each value (ABC, sequential number, year - or preferably a
whole date) in its' own field, and concatenate the values on the fly
wherever you need to display them.

hth
 
John said:
USE AUTONUMBER IN A CUSTOMISED NUMBER STRING WHICH WILL RESET BACK TO
1 AT THE START OF A NEW YEAR. EG ABC/462/2006 CHANGES
TO ABC/1/2007 AT TURN OF YEAR
Click to expand...

First I suggest turning off the Caps Lock Key. It is hard to read ALL
CAPS. It is makes me fell you are screaming at me.

I suggest you may not want to use Autonumber for that use. Autonumbers
are designed to provide unique numbers. It in not designed to provide
numbers in order and for a number of reasons may not do so. As a result
using them in any application where the user sees the numbers is likely to
end up with confusion.

There are other ways of providing the numbers you want depending on the
particual application.
 
Back
Top