can I update a data field in Access to include a prefix?

[Guest]

I have a Data Field of Client numbers that I need to add a prefix to (PRE)
before exporting to a text file to import into another program. Is there a
way the data field could be modified to include this prefix

 

[Guest]

Hi Ray,

If the prefix is just for this one-off export, there's no need to update the
table. Instead, create a query that uses a calculated field to add the prefix
'on the fly'. The calculated field will look like this in the query design
view (assuming that the Client Number field is called ClientNum):

ClientNumber: "PRE" & [ClientNum]

In case you want to change it permanently in your table:

1) Open the table in design view. If the ClientNum field is a number field,
change it to a text field with a suitable number of characters, and save the
table.

2) Create an update query that updates the ClientNum field to

"PRE" & [ClientNum]

 

[Guest]

John,
Thanks for your help - it worked perfectly!!!

Thanks again,
Ray Naylor

Hi Ray,

If the prefix is just for this one-off export, there's no need to update the
table. Instead, create a query that uses a calculated field to add the prefix
'on the fly'. The calculated field will look like this in the query design
view (assuming that the Client Number field is called ClientNum):

ClientNumber: "PRE" & [ClientNum]

In case you want to change it permanently in your table:

1) Open the table in design view. If the ClientNum field is a number field,
change it to a text field with a suitable number of characters, and save the
table.

2) Create an update query that updates the ClientNum field to

"PRE" & [ClientNum]

--
John Nurick
Microsoft Access MVP

I have a Data Field of Client numbers that I need to add a prefix to (PRE)
before exporting to a text file to import into another program. Is there a
way the data field could be modified to include this prefix

 

[Guest]

many thanks for this info - worked perfectly and also i pasted the change to
the main table in access

Tina

John,
Thanks for your help - it worked perfectly!!!

Thanks again,
Ray Naylor

Hi Ray,

If the prefix is just for this one-off export, there's no need to update the
table. Instead, create a query that uses a calculated field to add the prefix
'on the fly'. The calculated field will look like this in the query design
view (assuming that the Client Number field is called ClientNum):

ClientNumber: "PRE" & [ClientNum]

In case you want to change it permanently in your table:

1) Open the table in design view. If the ClientNum field is a number field,
change it to a text field with a suitable number of characters, and save the
table.

2) Create an update query that updates the ClientNum field to

"PRE" & [ClientNum]

--
John Nurick
Microsoft Access MVP

I have a Data Field of Client numbers that I need to add a prefix to (PRE)
before exporting to a text file to import into another program. Is there a
way the data field could be modified to include this prefix