Multiple Replacements

  • Thread starter Thread starter Gator
  • Start date Start date
G

Gator

Can I do unique multiple replacements? For example, I have over 50,000
records and I need to replace several different text with other text. Can I
do this in some SQL, code or query?....rather than doing it one at a time
through the Edit menu.
 
Hi Gator,

absolutely, you can use Update queries

UPDATE [tablename]
SET [fieldname] = 'textvalue_new'
WHERE [fieldname] = 'textvalue_current'

are the values that you are replacing stored in a table? If so, you can
link to the table in a query and automate it

there is more about SQL and Update queries in Access Basics

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"can’t replace the current value of the field" error 4
change multiple items in one field 1
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Access 2003 - Help with Make-Table and Append queries 3
Replace Function 2
Printing multiple forms with linked images...How can I make the images work? 0
Find and replace values across multiple fields 9
primary key - concatenated or autonumber? 6

Back
Top