How do I Convert Primary ID (Autonumber) to Text

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have the ID autonumber on to create a unique value for each record.

I want to auto create a second field in this table that is text.

So ID = the number 9, I want a field to auto populate that is IDText which
equals the letter 9

Is this possible?

Thanks

Dave
 
Are you entering data through a form? If so, you can simply have the new (text) field calculated from the ID field - use str([ID])

However, I have to ask why you want to do this in the first place? If it is for comparisons in calculations, you can use the str() function at calculation stage. If it is for join purposes, you can use the str() function in the sql join property - simply go into sql view of query and on the relevant join bit, surround the field name with str()

HT

Basi

----- Dave wrote: ----

I have the ID autonumber on to create a unique value for each record

I want to auto create a second field in this table that is text

So ID = the number 9, I want a field to auto populate that is IDText whic
equals the letter

Is this possible

Thank

Dav
 
Thanks

I am using it to have both a numeric and a text value for comparisons.

Dave

Basil said:
Are you entering data through a form? If so, you can simply have the new
Click to expand...
(text) field calculated from the ID field - use str([ID]).
However, I have to ask why you want to do this in the first place? If it
Click to expand...
is for comparisons in calculations, you can use the str() function at
calculation stage. If it is for join purposes, you can use the str()
function in the sql join property - simply go into sql view of query and on
the relevant join bit, surround the field name with str().
 
Back
Top