alienscript
Registered User.
- Local time
- Today, 15:02
- Joined
- Jul 17, 2004
- Messages
- 20
I got help with the Public Function below that will loop through a column of PartNumbers values and it strips the left characters out until it runs into one that isn't a zero.
I don't know how to call this Public Function in a Query ?
Would somebody be nice please show me how to do this (may be with steps) and thanks a lot.
Public Function StripZeros(strNum as String)
Do Until Left(strNum,1) < "0"
strNum = Right(strNum,Len(strNum)-1)
Loop
StripZeros = strNum
End Function
I don't know how to call this Public Function in a Query ?
Would somebody be nice please show me how to do this (may be with steps) and thanks a lot.
Public Function StripZeros(strNum as String)
Do Until Left(strNum,1) < "0"
strNum = Right(strNum,Len(strNum)-1)
Loop
StripZeros = strNum
End Function