G
Guest
How can I get my autonumber to start with the (Current Year) - Autonumber?
Any advice would be greatly appreciated, thanks!
Any advice would be greatly appreciated, thanks!
Jeff Boyce said:Peggy
If you are talking about the Access datatype called "Autonumber", don't!
First, the Autonumber in Access is designed to be a unique row identifier,
and is generally unfit for human consumption. It sounds like you are
considering using it for something folks would see.
Second, putting two facts into one field (Current Year) and Autonumber is
not a good design. Keep one fact in one field. Use a query to concatenate
the value from your [Current Year] field and your Autonumber field.
(you did say "any advice", right?!)
Regards
Jeff Boyce
Microsoft Office/Access MVP
Peggy said:How can I get my autonumber to start with the (Current Year) - Autonumber?
Any advice would be greatly appreciated, thanks!
Peggy said:I DID say any advice - and I do appreciate it.
So how would I go about creating this query to concatenate?
Sorry, I'm a basic Access user and this is getting a little advanced for
me.
Thanks!
Jeff Boyce said:Peggy
If you are talking about the Access datatype called "Autonumber", don't!
First, the Autonumber in Access is designed to be a unique row
identifier,
and is generally unfit for human consumption. It sounds like you are
considering using it for something folks would see.
Second, putting two facts into one field (Current Year) and Autonumber is
not a good design. Keep one fact in one field. Use a query to
concatenate
the value from your [Current Year] field and your Autonumber field.
(you did say "any advice", right?!)
Regards
Jeff Boyce
Microsoft Office/Access MVP
Peggy said:How can I get my autonumber to start with the (Current Year) -
Autonumber?
Any advice would be greatly appreciated, thanks!