PC Review


Reply
Thread Tools Rate Thread

access - Prefix in field

 
 
=?Utf-8?B?eWFr?=
Guest
Posts: n/a
 
      24th Jan 2007
how do I set up field (autoumber) to have TD as prefix
 
Reply With Quote
 
 
 
 
fredg
Guest
Posts: n/a
 
      24th Jan 2007
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
 
Reply With Quote
 
=?Utf-8?B?eWFr?=
Guest
Posts: n/a
 
      24th Jan 2007


"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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:42 PM.