two spaces to one without VB code ?

[techexpressinc]

I have this



fieldwithOnly1space: Replace([fieldwith2spaces],"bb","b")

with the b being a space.

And it is not working any suggestions.

Rus

[techexpressinc]

attached is the db with the example, no extra tables or fields just the basics.
Rus

[weekend00]

when I tried, it worked just fine.

In you query you put Replace([fieldwith2spaces],"bbb","bb"), not
Replace([fieldwith2spaces],"bb","b")

[techexpressinc]

it does not appear to work for me, see the Excel output.
Rus

[techexpressinc]

I had three space I switched it to 2 and the two to one works!
I get to eat a little crow but get happy customers which pay my bills.

Thx for the help.
Russ