FormatPercent Function - Access 2003

  • Thread starter Thread starter tg112001 via AccessMonster.com
  • Start date Start date
T

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!
 
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
 
Thank you!!

Conan said:
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,
Click to expand...
[quoted text clipped - 11 lines]
Thanks for any feedback!
Click to expand...
Click to expand...
 
Back
Top