Query - Add Characters to ID Numbers

  • Thread starter Thread starter P Brainard via AccessMonster.com
  • Start date Start date
P

P Brainard via AccessMonster.com

I'd like to solicit some help from you if I may. I'm looking for an answer to a simple query question and perhaps this will come off the top of your head.

I have a column of numbers. They are identification numbers.

500034
604403
504933
605504
etc.

What I want to do is run a query to add 01 after each number to match the indentification numbering logic of another system prior to export/import. Is this a simple task?

Thanks,

Paul
 
Is the field text or numeric?
Do you want to actually store the 01 or just display it?
Do you need to join the value (with the 01) to another field?

To display, just use:
MyField: [FieldName] & "01"
 
The field is text. I want to append the 01 to each field's data. Also, what would I need to do if I wanted to add incremental numbers to each field? (i.e. 01, 02, 03, etc.)

I want to be able to save the results for export.

Thanks.
 
Back
Top