How do I trim data from a field but data is not in all fields?

J

Jerry Whittle

Please provide examples of current data and what you wish it to look like
afterwards.
 
J

John W. Vinson

I want to trim data but not all the fields have the data?
Click to expand...

Probably with an update query using the Replace function, updating the field
to

Replace([fieldname], "Data You Want Gone", "")

but it's awfully hard to be sure given the brevity of your question.

John W. Vinson [MVP]
 
Top