access - Prefix in field

's Computer Specifications

how do I set up field (autoumber) to have TD as prefix

's Computer Specifications

On Tue, 23 Jan 2007 18:22:02 -0800, yak wrote:

> how do I set up field (autoumber) to have TD as prefix

You can't and you don't need to.

Whenever you need to show the Autonumber with the TD prefix,
concatenate it:
= "TD" & [NumberField]

There is no need to store the TDValue in the table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

's Computer Specifications

"fredg" wrote:

> On Tue, 23 Jan 2007 18:22:02 -0800, yak wrote:
>
> > how do I set up field (autoumber) to have TD as prefix
>
> You can't and you don't need to.
>
> Whenever you need to show the Autonumber with the TD prefix,
> concatenate it:
> = "TD" & [NumberField]
>
> There is no need to store the TDValue in the table.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail

kewl...thanx
concatenate... word du jour
> concatenate...word du jour

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
adding prefix - text field	KarenY	Microsoft Access	7	13th Aug 2008 06:54 PM
can I update a data field in Access to include a prefix?	=?Utf-8?B?UmF5IE5heWxvcg==?=	Microsoft Access External Data	3	22nd May 2007 02:43 PM
prefix a field	=?Utf-8?B?bGVl?=	Microsoft Excel Misc	1	12th Oct 2005 08:03 PM
Prefix in Field	May	Microsoft Access	2	26th Nov 2004 10:43 AM
Want to prefix my primary field data.	Charles	Microsoft Access	2	16th Sep 2003 01:56 PM