How do I append information to a field?

[eyost]

Hi all,

I have a database that contains information in a field that I need to append a .pfd to every entry in that field. For example, the data in the field is F:\Apps\123. I need to add the .pfd at the end so the data now reads F:\Apps\123.pfd.

I've tried a find/replace but couldn't get it to replace the static .pfd portion.

Any ideas?

Thanks,

Ed

 

[Axis]

A simple update query is all you need. First, make a backup of your database. Then, create a new query with the table you want, and select the field in question. Go to the menu under Query and select Update Query. In the 'Update To' row, put the name of the field in brackets followed by & ".pdf". For example, if the field name is PDFFile, put [PDFFile] & ".pdf". Then run the query.