data type

[Randal]

Is there a way to change data type from text to number during the execution
of a query?

 

[Lynn Trapp]

It depends on what type of Number you want, but you can use the following
functions:

CInt()
CDbl()

 

[Randal]

Thanks.

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