<div>
for your question 1<br />
<br />
place this in column in an UPDATE query<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;field &nbsp; Categories<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;table <br />
Update to &nbsp; &nbsp;Trim(Replace([Categories],<wbr /> &quot;SDBS&quot;,&quot;&quot;))
</div>


<div>
My original subject line asked about whether this could be done outside of a &quot;update query&quot;<br />
<br />
I don't want to change my original table, but change it in a query I am running for another group.
</div>


<div>
what exactly do you want to happen?
</div>


<div>
Here is what is happening. &nbsp;I have a user that connects to a query via multiple excel workbooks. &nbsp;We want to change some of the text of the records in that query but I don't want to change it for my main table and I don't want to change it for other queries other people are using. &nbsp;<br />
<br />
So I really just need to take a basic query and change the text in that one Category Column so it only affects the query he uses to connect to his excel file. &nbsp;I could probably do it in excel but there are 25 or so pivot tables connected to this information and it would take some time to fix it all in excel.
</div>


<div>
using a select query<br />
<br />
select Trim(Replace([Categories],<wbr /> &quot;SDBS&quot;,&quot;&quot;)) &nbsp;As Category<br />
from tableName<br />
<br />
is this what you want?
</div>


<div>
This looks like it might work, but where do I put it in the select query?
</div>


<div>
in the design view of a new query<br />
<br />
<b>Field:</b> &nbsp;Category:Trim(Replace([Cat<wbr />egories], &quot;SDBS&quot;,&quot;&quot;)) <br />
<b>Table:</b> tableName
</div>


<div>
Getting Syntax error<br />
<br />
<b>Syntax error (comma) in query expression 'ManageEngineData'.[Trim(R<wbr />eplace([Ca<wbr />tegories],<wbr />&quot;SDBS&quot;,&quot;&quot;)<wbr />)]'.<br />
<br />
</b>I copied your info word for word and my table name is &quot;ManageEngineData&quot; and this was selected in table field.
</div>


<div>
Please test this<br />

<pre><code class="code-1 nolinks" id="code-20-41431615-1"><span>Select Replace([Categories], &quot;SDBS Link&quot;, &quot;Messenger&quot;) As CleanedCategories</span>
<span>From MyTable</span>
<span>Where [Categories] = &quot;SDBS Link&quot;</span>
<span>Union All</span>
<span>Select Replace([Categories], &quot;SDBS &quot;, &quot;&quot;) As CleanedCategories</span>
<span>From MyTable</span>
<span>Where [Categories] &lt;&gt; &quot;SDBS Link&quot;</span>
</code></pre>
</div>


<div>
this in the dseign view of the query in the QBE (query builder editor)<br />
<br />
Field: &nbsp;Category:Trim(Replace([Cat<wbr />egories], &quot;SDBS&quot;,&quot;&quot;))<br />
Table: ManageEngineData<br />
<br />
this one is the SQL view of the query, you can copy this and paste directly to the SQL view of a NEW query<br />
<br />
select Trim(Replace([Categories],<wbr /> &quot;SDBS&quot;,&quot;&quot;)) &nbsp;As Category<br />
from ManageEngineData
</div>


<div>
If you have a lot of such substitutions, you should create a two-column table with the From and To values for your Categories data.
</div>


<div>
Rey - This worked great with a little experiment on my part. &nbsp;I could not get it to work in an existing query but it worked great in a new one. &nbsp;I then copied and pasted that Design View Column and pasted it into my older query and it did the trick. &nbsp;Thanks for sticking it through with me on this one. &nbsp;<br />
<br />
Now for part 2:<br />
<br />
In that same field is there a way to change the Word &quot;LINK&quot; (SINCE NOW IT ONLY SAYS LINK, and NOT SDBS LINK) to &quot;Messenger&quot; while keeping the same code to remove the SDBS?
</div>


<div>
aikimark - I would but that would mess up all the other user has in his connected Excel table. &nbsp;The columns need to stay as is with no other changes for it to work the way I need it to work. &nbsp;Rey has gotten me almost all the way there. &nbsp;Thanks for your help as well.
</div>


<div>
If you create a new query that renames the Categories column, you can point all other queries to that query, instead of the base table. &nbsp;That way, your transforming query can change the column back to Categories.
</div>


<div>
Rey was patient and really good
</div>


<div>
@rnhturner1<br />
<br />
Since Rey's solution renames the column, why is this more acceptable than my solution?
</div>


<div>
<div class="content wysiwyg-content">
I am running a query on a table and the query is all set with the exception of I need to change some text. &nbsp;KEEP in mind I am a newbie with ACCESS and I am making all changes from the &quot;Design View&quot; on a query. &nbsp;So if you are not using this route it will not help me that much right now.<br />
<br />
Question 1:<br />
I have a field name &quot;Categories&quot;<br />
I have multiple records like below under that field like below:<br />
<br />
SDBS SES<br />
AS400<br />
Exchange<br />
SDBS Link<br />
SDBS Microsoft<br />
<br />
I need to get rid of &quot;SDBS&quot; but then keep the rest of the string. &nbsp;So &quot;SDBS SES&quot; would only become &quot;SES&quot;<br />
<br />
This has to be in a query and not an update for my purposes.<br />
<br />
Question 2:<br />
<br />
I need to completely change the text of a record to something entirely different.<br />
<br />
For Example I need &quot;SDBS Link&quot; to be change to &quot;Messenger&quot;
</div>
</div>


I am running a query on a table and the query is all set with the exception of I need to change some text.  KEEP in mind I am a newbie with ACCESS and I am making all changes from the "Design View" on a query.  So if you are not using this route it will not help me that much right now.

Question 1:
I have a field name "Categories"
I have multiple records like below under that field like below:

SDBS SES
AS400
Exchange
SDBS Link
SDBS Microsoft

I need to get rid of "SDBS" but then keep the rest of the string.  So "SDBS SES" would only become "SES"

This has to be in a query and not an update for my purposes.

Question 2:

I need to completely change the text of a record to something entirely different.

For Example I need "SDBS Link" to be change to "Messenger"

Delete Text of a record under a field in an Access 2016 Query (not update query) and I need to replace Some Text Completely.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.