Inserting Characters into Fields that Already Contain Data

  • Thread starter Thread starter Damion
  • Start date Start date
D

Damion

Is there a way, when numeric characters are entered or
imported (via Excel) into a field in a table , to insert a
predetermined set of alpha characters in front of the
imported numeric characters?

For example I would import numbers (12345, 67890, 11111,
22222). Can I get the output to display as:

AAA12345
AAA67890
AAA11111
AAA22222

Any assistance would be greatly appreciated.

Damion
 
You can do this in a report by adding a text field with something like...

="AAA"&[FieldName]



If you wish to display your results in a query, you could add a field to the
query (in design view) with something like...

NewField: "AAA"&[FieldName]



If you wish to permanently update each item in the table, you would need to
create an update query. Use a similar string as above to ubdate the field.


Rick
 
The update query worked perfectly. Thank you.
-----Original Message-----
You can do this in a report by adding a text field with something like...

="AAA"&[FieldName]



If you wish to display your results in a query, you could add a field to the
query (in design view) with something like...

NewField: "AAA"&[FieldName]



If you wish to permanently update each item in the table, you would need to
create an update query. Use a similar string as above to ubdate the field.


Rick



Damion said:
Is there a way, when numeric characters are entered or
imported (via Excel) into a field in a table , to insert a
predetermined set of alpha characters in front of the
imported numeric characters?

For example I would import numbers (12345, 67890, 11111,
22222). Can I get the output to display as:

AAA12345
AAA67890
AAA11111
AAA22222

Any assistance would be greatly appreciated.

Damion
Click to expand...


.
Click to expand...
 
The update query worked perfectly. Thank you.
-----Original Message-----
You can do this in a report by adding a text field with something like...

="AAA"&[FieldName]



If you wish to display your results in a query, you could add a field to the
query (in design view) with something like...

NewField: "AAA"&[FieldName]



If you wish to permanently update each item in the table, you would need to
create an update query. Use a similar string as above to ubdate the field.


Rick



Damion said:
Is there a way, when numeric characters are entered or
imported (via Excel) into a field in a table , to insert a
predetermined set of alpha characters in front of the
imported numeric characters?

For example I would import numbers (12345, 67890, 11111,
22222). Can I get the output to display as:

AAA12345
AAA67890
AAA11111
AAA22222

Any assistance would be greatly appreciated.

Damion
Click to expand...


.
Click to expand...
 
Back
Top