Remove Character from field

[DT]

I need to remove a character imbetted in the middle of a field (example:
remove the "." from 33.22620). The character is always in the same position,
in this case the third character from the left. Thanks for you help

DT

 

[Juan]

Why dont you just multiply the number by 100000 and you will get
3322620.

 

[Jerry Whittle]

Check out the Replace function:

Debug.Print Replace("33.22620", ".", "")

Just make sure that it's a text field and not a number.

 

[DT]

Perfect...thank you!

Check out the Replace function:

Debug.Print Replace("33.22620", ".", "")

Just make sure that it's a text field and not a number.