On Tue, 4 Nov 2003 17:02:08 -0800, "Lauren" < XXXX@XXXXX.COM >
YOu can use the Replace() function to do this. I think in another
thread you said that you were using A2002 (and please, keep questions
to the same thread rather than starting a new one!).
Update the field to
Replace([Field2], "xx", "")
This will find each instance of the string xx in Field2 and replace it
with a null string, and then update Field2 to the result.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday