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

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