Cynthia
Last Activity: Feb 27 '07, 06:10 PM
Joined: Jan 4 '07
Location: California
-
Yes please, manual entry makes me quiver.... -
Auto incrementing
I am trying to design a database that will automatically enter a unique ID for a field that would look like 07-001, (the first 2 digits are the year, a dash, followed by a 3 digit number that auto increases from Jan 1 till Dec 31), then resetting to 08-001 at the beginning of the next year etc.
Does this even make sense? -
Access auto increment question
Good morning, i am new to the forums, and have a question.
I inherited a database (housed in Excel) containing over 8,000 records [yikes!] which i am trying to import into a database, this will be a flat file for now; Access is the only option i currently have.
Our unique ID is year (last 2 digits) then starts at 001 on January 1st, etc, this is a breeze in Excel.
Is it possible to have a field (or 2)...
No activity results to display
Leave a comment: