Abdul-
Yes, as long as all the numbers are two digits and are no larger than 99. For
example, lower numbers must be 01, 02, 03, etc., NOT 1, 2, 3. Just use DMax
where the key is LIKE "ATC/L12/*" - strip off the last two digits into an
Integer, add 1, then put it back with Format(intValue, "00").
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul Shakeel
Sent: Monday, August 13, 2012 10:29 AM
To: MS_Access_Professionals@yahoogroups.com
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]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar