Text and number

[adnancanada]

I have result in query destination id



Destination Id:

03 it should be text
04 it should be text
14 it should be integer
25 it should be integer
15 it should be integer

My field name is destination Id Integer . I want my result if destination is from 1 it should show 01 as text if destination id 2 it should 02 as text if destination id 15 it should show as integer.

leading zero changed my entire field to text which I don't want. I want from 1 to 9 as text and 10 to 50 as integer. -Hope you understand. Your help is needed.

[RuralGuy]

You can use the Format() function to display the integer any way you want. Access is pretty good at separating what is in the table from how it is displayed.