How do I Convert Primary ID (Autonumber) to Text

[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

 

[Guest]

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

 

[Dave]

Thanks

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

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().