471,355 Members | 1,589 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,355 software developers and data experts.

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

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
2 2031
MMcCarthy
14,534 Expert Mod 8TB
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
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.

Similar topics

17 posts views Thread by Jon Ole Hedne | last post: by
26 posts views Thread by Dragon | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.