Full Version: Convert a string to integer
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
PropMgr
May 6 2010, 12:50 PM
Convert a string to integer

TranID = "Exp-232"
TransNumber = mid(TranID,5)

Thanks Michael
RAZMaddaz
May 6 2010, 12:57 PM
CInt([Formula or Field])
PropMgr
May 6 2010, 01:03 PM
Got it thanks -
I think the big issue was that I had a typo which screwed up the function.
Michael
RAZMaddaz
May 6 2010, 01:25 PM
Awesome!!! Glad I could help!!!

RAZMaddaz
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.