Need to create a unique ID incorporating date

P

PenfoldCBUK

Joined
Jun 23, 2005
Messages
3
Reaction score
0
The problem is this. I have produced a DBase with the main data having its own ID per record. I have now been asked to give each record an additional code based on the date recorded.

The layout will be [SerID]/[Year] eg 0001/06 for the first record of 2006. The [SerID] needs to be consecutive but also refresh to 0001 at the start of every year.

I'm guessing it will have to be coded into the system to write the data into my table instead of querying every time

Any help most appreciated!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique ID/Duplicate Entry 3
Create a unique ID using dates? 4
COMBINING UNIQUE VALUES FROM 4 COLUMNS INTO 1 5
ID number 4
Calculate Average In Report? 1
Create ID with consecutive numbers by month 5
How to build a "reach around" query? 5
Part Autonumber 2

Back
Top