Is there a way to change data type from text to number during the execution of a query?
R Randal Apr 28, 2004 #1 Is there a way to change data type from text to number during the execution of a query?
L Lynn Trapp Apr 28, 2004 #2 It depends on what type of Number you want, but you can use the following functions: CInt() CDbl()
R Randal Apr 29, 2004 #3 Thanks. Lynn Trapp said: It depends on what type of Number you want, but you can use the following functions: CInt() CDbl() -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Click to expand...
Thanks. Lynn Trapp said: It depends on what type of Number you want, but you can use the following functions: CInt() CDbl() -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Click to expand...
