Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

add a character to an exisitng word in an Access Query

Posted on 2008-10-23
1
Medium Priority
?
299 Views
Last Modified: 2013-11-27
I have an Access query and one of the fields has the letters PPOP in it.  Example

Field1
PPOP
PPOP
LIGHT
LONG
PPOP

Just for this query I want it to show
POP
POP
LIGHT
LONG
POP

It can not be changed in the database because it is need at other times the other way.
0
Comment
Question by:Pdeters
1 Comment
 
LVL 9

Accepted Solution

by:
jamesgu earned 2000 total points
ID: 22784787
select replace(Field1, 'PPOP', 'POP' from <your_table>
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question