T
Toni
Newbie in need of help!! Using an ID that is made up of w/ 2 digit year
plus 3-digit sequential number. 1st record for 2008 would start 08-001, then
08-002. In 2009 it would start over 09-001, 09-002. Trying to setup in
access database. I got it to work using auto number w/ format, but don't
know how I will be able to change when new year starts. (It changes all the
previous records from 08 to 09 when I change the format.) Also if I use
auto number for primary key then I can't use auto number again in same table,
I think. Also each ID # must be accounted for so no deletes. Thanks.
plus 3-digit sequential number. 1st record for 2008 would start 08-001, then
08-002. In 2009 it would start over 09-001, 09-002. Trying to setup in
access database. I got it to work using auto number w/ format, but don't
know how I will be able to change when new year starts. (It changes all the
previous records from 08 to 09 when I change the format.) Also if I use
auto number for primary key then I can't use auto number again in same table,
I think. Also each ID # must be accounted for so no deletes. Thanks.