Inserting Characters into Fields that Already Contain Data

[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

 

[Rick]

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

 

[Guest]

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

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

.

 

[Guest]

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

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

.