FormatPercent Function - Access 2003

  • Thread starter tg112001 via AccessMonster.com
  • 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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
What Qualifies as a "Numeric Expression"? 2
Control Select Query Output Field Type 8
... FormatPercent Function ... 1
Formatting Percentages Redux 4
help Restructure query 0
Ranking Query For Multiple Groups using percentages 1
Calculating a percentage using the current month 0

Top