I want to add an alphabet to ...

[raghuprabhu]

I have a number field ServiceNo. It has 7 digits maximum. First I want to change it to a text field then I want to add an alphabet to this field on the left hand side.

For example if the number is 8014342 I want to add A to the right and make it A8014342.

I want to change the field to a text field and store the new value.

What function or query do I use?

Cheers
Raghu Prabhu

 

[ajetrumpet]

would simply be:

SELECT "a" & cstr([fieldname]) as NewFieldName

 

[highandwild]

If you want to change the data in the table then this query would do the trick:

UPDATE YourTableName SET YourTableName.ServiceNo = "A" & [YourTableName]![ServiceNo]

 

[raghuprabhu]

Thanks a lot for this suggestion.

Raghu