autonumber field with letter

[amna77]

hi , is there a way that i can add letter infront of autnumber field. I mean instead of , 1, 2, and 3, I am looking for T1, T2, T3.

can someone help me please.

Thanks

 

[Norie]

Where do you want this? In a query, table or form?

You won't be able to do it in a table using Autonumber but could create a calculated field in a query or form.

 

[Corticus]

I would use a calculated query as Norie suggests, but you can also format the autonumber field for the desired table like:
\T#
Just view the table in design view, select the autonumber field, and enter the above under "Format"

 

[amna77]

Thanks Corticus, In my autonumber field format, i put T-##, and its working, its putting T and number as I was looking for.
Thanks for help.