Removing Spaces in a string

H

hdfixitup

What Function or ??? can I use to remove blank spaces within a string?
Example: FS 8406 PT 1 to read FS8406PT1. Anyone with any ideas.

thanks in advacnce
 
H

hdfixitup

So Simple, Thank you

KARL DEWEY said:
Replace([YourFieldName], " ","")
--
KARL DEWEY
Build a little - Test a little


hdfixitup said:
What Function or ??? can I use to remove blank spaces within a string?
Example: FS 8406 PT 1 to read FS8406PT1. Anyone with any ideas.

thanks in advacnce
Click to expand...
Click to expand...
 
Top