Removing Spaces in a string

[Guest]

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

 

[Guest]

Replace([YourFieldName], " ","")

 

[Guest]

So Simple, Thank you

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

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