formatpercent sort

I

iccsi

I use formatpercent to format my results which works. The only thing
is it considers as a string. 100% is smaller than 2 %, but not greater
than 99 %.

Are there any workaround to sort formatpercent results?


Your help is great appreciated,
 
K

KARL DEWEY

Use a second unformated field to sort on. You can also turn off the display
by unchecking the box in row 'Show'.
 

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

Formatting Numbers with Plus or Minus Sign 3
Trouble switching syntax from IIf to Switch 3
What Qualifies as a "Numeric Expression"? 2
Formatting Percentages Redux 4
FormatPercent Function - Access 2003 0
SQL syntax error with vba 3
... FormatPercent Function ... 1
Calculating a percentage using the current month 0

Top