Combining an Autonumber field & a Text field

[aussie1855]

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

 

[fredg]

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.