Add character to end of string

[Steve_A]

I am working with some data to add a ; to the end of a sting (Filed) so the
data can be loaded into another system.

All the data is different length up to 44 character filed length, I need to
run my update query selecting data from a different field and up date this
text string.

Is now
CBDE1234
RSE142646-109

Need to be
CBDE1234;
RSE142646-109;

Thanks

 

[Allen Browne]

Create a query.

Type an expression like this into the Field row:
[F] & ";"
replacing the F with your field name.

Export the query.

 

[Jerry Whittle]

In the Update To:

[TheFieldName] & ";"

 

[Steve_A]

Thanks Jerry and Allen, that one was pretty simple, I was looking for
something hard

Thanks again guys

Create a query.

Type an expression like this into the Field row:
[F] & ";"
replacing the F with your field name.

Export the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am working with some data to add a ; to the end of a sting (Filed) so
the
data can be loaded into another system.

All the data is different length up to 44 character filed length, I need
to
run my update query selecting data from a different field and up date this
text string.

Is now
CBDE1234
RSE142646-109

Need to be
CBDE1234;
RSE142646-109;

Thanks

.