I have a table that has values that are data type test, My values in text look like this:
2.62
5.00
60.00

Is there a way in a query to format this text as a numeric percent of:
2.62%
5.00%
60.00%

I have a table that has values that are data type test, My values in text look like this:
2.62
5.00
60.00

Is there a way in a query to format this text as a numeric percent of:
2.62%
5.00%
60.00%

You can use

Format(Val([YourFieldName])/100,"percent")

SOS,

Good God! that works. And correctly as well. Easy enough.

Thanks!