By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Access auto increment question

P: 3
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) make up a uniqueID that changes the year, and resets to 001 at the beginning of a new year?

Hope you can help,
Cynthia

I have used databases for years, but have never designed one.
Jan 4 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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) make up a uniqueID that changes the year, and resets to 001 at the beginning of a new year?

Hope you can help,
Cynthia

I have used databases for years, but have never designed one.
Cynthia

This can only be done by using VBA code. If you want further instruction let me know.
Jan 5 '07 #2

P: 3
Cynthia

This can only be done by using VBA code. If you want further instruction let me know.
Yes please, manual entry makes me quiver.
Feb 26 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.