Number fields exporting as text ???

[DB88]

Hello,



I want to export the results of a query to Excel. All of the fields in the query are number fields. But when I export to Excel, the fields are stored as text. In fact I get the error message "number fields stored as text" in Excel.

Anyone know why this is happening?

Thanks

[June7]

Does the query have fields created with expressions? Post the sql of the query for analysis.

[DB88]

Yes, it does have expressions.


SQL:
SELECT Nz([RDTE]*(1/[InflationIndex]),0) AS BY_RDTE, Grab_BaselineData.[_kf_year], Nz(IIf([Grab_BaselineData]![_kf_year]>[Grab_BaselineData]![version_CurrentFY],[Grab_BaselineData]![AP_Est],[Grab_BaselineData]![AP_Actual]*(1/[InflationIndex])),0) AS BY_AP, Nz(IIf([Grab_BaselineData]![_kf_year]>[Grab_BaselineData]![version_CurrentFY],[Grab_BaselineData]![OM_Est],[Grab_BaselineData]![OM_Actual]*(1/[InflationIndex])),0) AS BY_OM, [BY_RDTE]+[BY_AP]+[BY_OM] AS BY_Total, Grab_BaselineData.kp_versions
FROM Inflation INNER JOIN Grab_BaselineData ON (Inflation.Year = Grab_BaselineData.[_kf_year]) AND (Inflation.BaseYear = Grab_BaselineData.BaseYear);

[June7]

Unfortunately, the Nz function actually returns a text value. Try:

Val(Nz([RDTE]*(1/[InflationIndex]),0))