I have a query that includes calculated fields that generate numeric results.
I have wrapped conversion functions CLng() and CDdl() around the calculated
fields to ensure the data types are correct. The query results are correct
in MS Access 2007 but when I export to MS Excel 2007, some of the numeric
fields are converted to text. I cannot find an explanation. I am using a
Macro to export, and would prefer to avoid VBA for this simple task. Any
ideas?
Example: The following calculated field exports as a number to Excel, as
expected
Solar kW: CLng(([Solar kW (AC)]*[Solar_Model]![Model
Size])*(1+[Solar_Model]![Solar_Degradation]*-1)^([Year#]-1))
While the following calculated field is interpreted as text by Excel
Adj Site kW: CLng([Site kW]-[Solar kW])
Note that "Adj Site kW" is calculated by subtracting the calculated field
"Solar kW" from the field "Site kW".
--
mkbrady - Thanks!
Cold and confused in Minnesota.