Abdul,
In this context, my sample db named AppendSequence might also be of interest to you. It is in access 2000 file format and is available at Rogers Access Library. Link:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
The db demonstrates two modes (i.e. (i) Batch mode for bulk appendment from source to target table, and (ii) Data entry mode - one record at a time) - for automatic insertion of following types of sequential values:
(a) Pure sequential numbers
(b) Sequential number strings with date prefix (numeric portion starts afresh for each date).
(c) Similar to (b) above, but with YearMonth prefix (numeric portion starts afresh for each YearMonth).
(d) Similar to (b) above, but with Year prefix (numeric portion starts afresh for each Year).
(e) Sequential strings with alpha-numeric prefix (caters for multiple parallel series).
(f) Linked sub-sequential values
In data entry mode, if the record having existing highest sequential value is deleted, the value gets re-used on insertion of next record, thus preventing any holes.
For your current requirement, option (e) above should be pertinent.
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: Abdul Shakeel
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, August 13, 2012 13:59
Subject: [MS_AccessPros] DMAX Alpha Numeric Values
Dear All
In a Table value are stored like this
ATC/L12/12
ATC/L12/13
ATC/L12/14
ATC/L12/15
How do I increment values after "ATC/L12/", could it possible with help of
DMAX+1 function
--
Regards,
Abdul Shakeel
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar