hi,
how do you use a query for the find and replace function
thanks!
hi,
how do you use a query for the find and replace function
thanks!
You can use and update query for this.
Google: access 2003 update where
http://www.techonthenet.com/access/queries/update2.php
also try https://www.accessforums.net/showthr...es-it-not-work
hi....umm i have a very stupid doubt here....how do i make a query with a code, i have all this while being making a query in design view itself...
thanks!
also...what i want to find is not the whole cell, but only a part of the cell..
e.g. the entry in the table is 'i love ice-cream'
where i want to find 'ice-cream' and replace it with 'chocolate'
Is it static, i.e will it always be find 'ice-cream' and replace it with 'chocolate'? or will it change to different things?
Also it helps if you give your table structure and field name, then we might be able to give you a more specific answer.
The more detail you give about your problem, the more detail we can give you on how to solve it.
It might be worth you having a look at this too
http://www.brainbell.com/tutorials/m...te_Queries.htm
it is static
i want to change all the cells in a table that have 'i love icecream' or 'i love pizza' to 'i love chocolate'.
my table has two columns.
the first column has a person's name and the second has either 'i love icecream' or 'i love pizza'
that's it
I'm going to make some examples here then.
lets say your table is called Tbl_test
Tbl_test
Fields
First_Name, Remarks
Then for your basic example it could be accomplished with
UPDATE Tbl_test SET Tbl_test.Remarks = "I Like Chocolate"
WHERE (((Tbl_test.Remarks) Like "*" & "ice cream" & "*"));
I have enclosed a sample so you might see how it is done better
i dint realize you would understand it this way..sorry my mistake.sorry sorry
well the problem statement is actually as follows:
i have stuff like " i love icecream", "he loves icecream", "she loves icecream", etc and i want to change only the icecream part