Jul 16, 2001 #1 troyu Programmer Joined Nov 21, 2000 Messages 185 Location CA What is the command to convert a string value to an integer value? I would like to do this through a MS Access query. Please help.
What is the command to convert a string value to an integer value? I would like to do this through a MS Access query. Please help.
Jul 16, 2001 #2 DougP MIS Joined Dec 13, 1999 Messages 5,985 Location US Int(yourstring) DougP, MCP Visit my WEB site http://www.barcodeone.com to see how Bar-codes can help you be more productive Upvote 0 Downvote
Int(yourstring) DougP, MCP Visit my WEB site http://www.barcodeone.com to see how Bar-codes can help you be more productive
Jul 16, 2001 1 #3 RippleJD Programmer Joined Sep 26, 2000 Messages 18 Location US Try the function CInt(). Upvote 0 Downvote