Exclude characters

[cself]

Hello, this is my first time to post.



In a field that contains numbers and special characters (eg. 77# or 3817#), how do drop the # using query criteria?

Thank you very much.

cself

[orange]

Review this to see if it applies https://www.techonthenet.com/access/...umeric/val.php

[alansidman]

Here's a tutorial on how to manipulate data in a query.

http://www.datapigtechnologies.com/f...anipulate.html

[ssanfu]

If the special characters will ALWAYS be at the end, you might try the VAL() function.

?val(77#)
77
?val(3817#)
3817

If MyField = "78#"
Val(MyField) =78

-See HELP-

[cself]

If the special characters will ALWAYS be at the end, you might try the VAL() function.

?val(77#)
77
?val(3817#)
3817

If MyField = "78#"
Val(MyField) =78

-See HELP-

Thank you all very much!
cself