auto increment Id no

CrossVampire's Avatar, Join Date: Feb 2011
Light Poster
hi., I'm using MS Access for the Database and visual basic 6.0 for programming. I was just wondering how to auto increment ID number with a format of (Year-Month-Id#).. Please i need some help... Can you help me..? Please... Thanks in Advance.!!
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Get the last id and increment it by one or store the last id in some settings file.
CrossVampire's Avatar, Join Date: Feb 2011
Light Poster
ah, then whats the data type for the ID number? was it Text?
CrossVampire's Avatar, Join Date: Feb 2011
Light Poster
the format is (Year-month-ID#) and how am i going to increment that?