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

ACCESS HELP: creating auto ID (not 1,2,3) but with other combination

P: 6
Hi,

I need help in getting this database to work well (user-friendly) by generating auto client ID. The ID is NOT the auto number that Access automatically create when there is no primary key.

For example: 1/1/2006 ; 2/1/2006; 3/1/2006

The first number represent the client number and,
the second number represent the month of January and,
the last number represent the year

so i want the first number is automatically generated and the second number is generated based on the today's month. How do i do the sql program thing to make the auto numbering works. or if i can do it on the design.

need help here...
thanks
Nov 28 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Please post this question in the Access forum.

http://www.thescripts.com/forum/forum142.html

Hi,

I need help in getting this database to work well (user-friendly) by generating auto client ID. The ID is NOT the auto number that Access automatically create when there is no primary key.

For example: 1/1/2006 ; 2/1/2006; 3/1/2006

The first number represent the client number and,
the second number represent the month of January and,
the last number represent the year

so i want the first number is automatically generated and the second number is generated based on the today's month. How do i do the sql program thing to make the auto numbering works. or if i can do it on the design.

need help here...
thanks
Nov 28 '06 #2

P: 6
Thanks for letting me know. I am a first timer to join the forum.

Thanks again, i really appreciate it.


Please post this question in the Access forum.

http://www.thescripts.com/forum/forum142.html
Nov 29 '06 #3

Post your reply

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