If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining an Autonumber field & a Text field
I have a table where I need to combine a auto-number field and a text field
to creat a new field which can be either a number or text. Any suggestions on how to do this Thanks Michael |
#2
|
|||
|
|||
Combining an Autonumber field & a Text field
On Sun, 9 Nov 2008 16:49:00 -0800, aussie1855 wrote:
I have a table where I need to combine a auto-number field and a text field to creat a new field which can be either a number or text. Any suggestions on how to do this Thanks Michael In a table? Why would you want to? Which do you want first? Leave the Table's AutoNumber and the Text field alone. Then whenever you need the combined values, concatenate them. In a query: NewColumn:[TextFieldName] & [NumberFieldName] Or directly in a form or in a report, using an unbound control: =[TextFieldName] & [NumberFieldName] No need to save this calculated value. Any time you need it, re-calculate it as above. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|