Want to prefix my primary field data.

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

Hello,

I have simple single table database created in access. At present all the
items are referenced by their unique ID (1, 2, 3, ...,n - one item per
record). I want to prefix all the unique ID numbers with IT (IT0001). I
have quite a few records in the DB and don't want to have to manually modify
all 2096 IDs.

Please can someone help?

Thak you.
 
You don't necessarily have to change your data to do this.
Any queries you create that use the Unique ID can be
changed quite easily to display the format you need.

In any queries where you have selected the Unique ID
Number, just add "IT"& in front of the field name.

If the field was called UniqueID, then you would change it
to "IT"&[UniqueID]. The query will then
display "IT001", "IT002" etc
 
Hi,
but this will be a problem because the real data doesn't
change.
-----Original Message-----
You don't necessarily have to change your data to do this.
Any queries you create that use the Unique ID can be
changed quite easily to display the format you need.

In any queries where you have selected the Unique ID
Number, just add "IT"& in front of the field name.

If the field was called UniqueID, then you would change it
to "IT"&[UniqueID]. The query will then
display "IT001", "IT002" etc


-----Original Message-----
Hello,

I have simple single table database created in access. At present all the
items are referenced by their unique ID (1, 2,
Click to expand...
3, ...,n -
one item per
record). I want to prefix all the unique ID numbers
Click to expand...
with
IT (IT0001). I
have quite a few records in the DB and don't want to
Click to expand...
have
to manually modify
all 2096 IDs.

Please can someone help?

Thak you.


.
Click to expand...
.
Click to expand...
 
Back
Top