Results Formats

[cbetts75]

Hi,

Is it possible to change the resulting format of a new field (expression) within a query?
I.e. Instead of the resulting when running query being displayed results in decimal places but instead being displayed in percentages

Regards

 

[KenHigg]

Have you tried the formatPercent() function:

FormatPercent([myFiledName], 2)

Where 2 is the number of decimal places to display.

 

[cbetts75]

Thanks Ken

 

[KenHigg]

You're welcome.