Data Type Conversion Help

[RhoSigma]

Simply put how do I convert the type of the result of the operation in the () from LONG to DOUBLE in the snippet below?

Code: (Select All)

Answer# = 1.0 + (ARowEnd& - ARowStart&)

Thanks

TR

Just use that line of code as is, you already specified Answer as DOUBLE using the # suffix, whatever the type of 1.0 + (ARowEnd& - ARowStart&) will evaluate to (probably SINGLE) will be automatically converted under the hood to mach your specified Answer# type.