Inserting text in front of record

[wutaguy]

I have a field and in front of all records in this feild I would like to add a fixed text. e.g. if the record is XYZ i want to add abc in front to make it abcXYZ. Sorry newbie here.
ThaNKS

 

[ScottGem]

What are you doing this? Does the prefix vary based on the value of the field? Is this a one time update or what?

 

[wutaguy]

I usually send out thousands of records to another company for inquiry of some data (i wish i could get into details but I am not supposed to). Now this company wants the data or each records to be formatted in a certain way for them to run my data through an automated process and I get correct results back from this company. What I have is all records that all should have a certain prefix which is the same for all. If I have a few then I can put the prefix manaully but imagine 20000 records.
Thanks

 

[ScottGem]

If that all have the same prefix, then just do it in a query:

newfield: "abc" & [Oldfield]

Then export the query.

 

[raskew]

Hi -

An update query should do it. Something like:

UPDATE myTable SET myTable.MyField = "abc" & Trim([MyField]);



HTH - Bob

 

[wutaguy]

THANKS!!! Update command works like a charm.

 

[sam saunders]

something slightly differant

I have a report running in cristal reports generator , on a report I need to have a object which consists of a "*" at the front of a data field and at the also back.
This * triggers the data in the field when printed to apear as a bar code font

Thanks
Sam

 

[ScottGem]

You can do this either in your query or a calculated field on the report. Just concatenate the asterisks around the barcode value.