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

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

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

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

newfield: "abc" & [Oldfield]

Then export the query.

Hi -

An update query should do it. Something like:

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



HTH - Bob

THANKS!!! Update command works like a charm.

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

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