On 28 Mar 2006 15:43:42 -0800,
ca*******@hotmail.com wrote:
replace([field1]," ",:" ")
When replying to a message, it's good practice to include the relevant
part of the previous message.
No one here charges by the word.
What does this message tell me?
What's the semicolon doing there?
Are you trying to replace 2 spaces with 1?
[Field1] = Replace([field1]," "," ")
Is there a reason why you didn't give the rest of the information I
asked for?
What does your existing data look like?
What do you want it to look like after any changes?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail