update query that removes extra spaces in the sentence

[alinapotter]

I am totally lost. I have a Sentence field that contains sentences with extra spaces in the middle and before tbe period.


For example: I need to buy a new compu ter this month. (3 spaces)
This book is about Fre nch Revolution. (3 spaces)
Lets go to the lake tomorrow . (4 spaces before period)

I need to create an update query which removes extra spaces before the period and create another query which removes 3 spaces in the middle.

First, I run this: Replace([Sentence]," ","") and it removes 3 spaces in the middle and 3 spaces before the period. BUT I am still left with an extra space before the period. What should I do?

[rpeare]

replace([Sentence], " .", ".")

would work wouldn't it? if you've got 3 spaces before the period

replace([Sentence], " .", ".")

if you've got 4 spaces before the period

or you can run a secondary update after you run your first one to just replace anything with a space period

replace([Sentence], " .", ".")

[alinapotter]

Thanks, it worked