Combining an Autonumber field & a Text field

  • Thread starter Thread starter aussie1855
  • Start date Start date
A

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
 
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
Click to expand...

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.
 
Back
Top