FormatPercent Function - Access 2003

[tg112001 via AccessMonster.com]

Hi,

I have a query with one of the columns using the FormatPercent function.
When I output this to an Excel spreadsheet, the percentage value shows up as
text format. Is there a way in Access to change the percentage value from
text datatype to number datatype before a user can output the query to an
Excel spreadsheet?

For example, query value = 90%
After OutputTo XLS, I still need the value as "90%" but recognized as number
format so sorting would be correct.

Thanks for any feedback!

 

[Conan Kelly]

tg112001,

Eliminate the FormatPercent function, return just the column (or
calculation) by itself, and format the column as a percent with as many
decimal places you require.

Right-click one of the "cells" in the column/field/calculation of the grid
in Query Design View > Properties > set Format to Percent > set the number
of decimal places (2 is default)

HTH,

Conan

 

[tg112001 via AccessMonster.com]

Thank you!!

tg112001,

Eliminate the FormatPercent function, return just the column (or
calculation) by itself, and format the column as a percent with as many
decimal places you require.

Right-click one of the "cells" in the column/field/calculation of the grid
in Query Design View > Properties > set Format to Percent > set the number
of decimal places (2 is default)

HTH,

Conan

Hi,

[quoted text clipped - 11 lines]

Thanks for any feedback!