Sequential Numbering

[lyncha]

Hi,

I am trying to create a sequential number for each new record added to a table via a form.

The number also needs to contain the curent year which will need to be updated.

The format of the sequential number shoudl be in the following format 'INT11-123' with '11' being the current year.

I am by no means an adavnced user of Access so any help would be greatly appreciated.

Many thanks in advance

 

[Galaxiom]

This topic has been covered many times in the forum.

Google this:
"sequential number" site:www.access-programmers.co.uk

I would not store the the INT or the dash but generate them for display.

 

[vbaInet]

I would not store the the INT or the dash but generate them for display.

...using the Format property.

 

[CBrighton]

I would use an autonumber field and combine that with things like Year([DateRecordCreated]) to create the reference number in all my queries.

However, it's worth keeping in mind the limits of autonumber such as missing numbers (from deleted records) not being reused. This means your "sequantial" number could be missing numbers in its sequence.

:edit:

I'd also like to point out that 2 digit year is fine for the near future (we near the start of the century) but if you have stuff dated <2000 you will have issues identifying the year from 2 digits. This may or may not apply to you depending on your data.