Re: a search and replace query

Tech-Archive recommends: Fix windows errors by optimizing your registry

You would either have to do the fields one-by-one (though you can update all of them in the same query), or you can simply open the table in Access's GUI and do your search & replace from there. If you take the second approach, it'll take longer to do the replace, but it's far easier than setting up a six-column update.

To do the multi-column update, use the following:

Update tblContacts Set tblContacts.[HomeAddressStreet] = Replace([HomeAddressStreet],"&","and"), tblContacts.NextField = Replace([NextField],"&","and"), etc.


Rob
.

Relevant Pages

  • Re: a search and replace query
    ... It's useful to speed things up, and particularly important if you're using replication or some other kind of change-tracking, but not strictly necessary, no. ... If you find the query below is inordinately slow, then you could do it as six separate queries and re-include the WHERE statement. ... Rob ... Update tblContacts Set tblContacts.= ...
    (microsoft.public.access.modulesdaovba)
  • RE: Table selection in Query
    ... "Rob" wrote: ... > Hey xRoachx ... > input table or query ......etc " ... >>> Union query will not work as the monthly table name is variable. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Delete query date field pulling more than one month
    ... but rethinking this from a duplicate stand point. ... The append query will ... Thanks Rob you have already lead me in the right direction, ...
    (microsoft.public.access.queries)
  • Re: Parameters Expression In A CrossTab Query
    ... Thanks for the tip Rob, I did what you suggested an it worked fine so many ... TRANSFORM SumAS SumOfAmt ... You need either a WHERE or HAVING clause in your query, ...
    (microsoft.public.access.reports)
  • Re: Delete query date field pulling more than one month
    ... Rob I really appreciate the time you have put into this headache of mine. ... I hope you can help me with this IIf syntax for one query. ... FROM Q1 INNER JOIN tblMtdYtdAllRolling ON (Q1.MinOfDateEntered = ... Query Q3 - just deletes those IDs ...
    (microsoft.public.access.queries)