texasalynn
Registered User.
- Local time
- Yesterday, 19:57
- Joined
- May 30, 2002
- Messages
- 47
I have a field that has data
S-TW--S Len=4
---WTF- Len=3
--T-T-- Len=2
etc
I need to query this to give me a "LEN" without the "-". I know how to do this in excel with the substitute function. How do I get this in access?
texasalynn
S-TW--S Len=4
---WTF- Len=3
--T-T-- Len=2
etc
I need to query this to give me a "LEN" without the "-". I know how to do this in excel with the substitute function. How do I get this in access?
texasalynn
