Format Function - Percent

[MDW]

Hey all

When I use the Format([COLUMN],"Percent") syntax in a query, the result is in the desired format, but it has 2 places after the decimal point. Any way to specify if I only want 1?

 

[Brian Camire]

Try:

Format([COLUMN], "0.0%")

Hey all,

When I use the Format([COLUMN],"Percent") syntax in a query, the result is

in the desired format, but it has 2 places after the decimal point. Any way
to specify if I only want 1?

 

[Brian Camire]

Yes. Check the "See Also" link in the "Format Function" topic in the help.

If you're using Access 2000 (or later?), you'll need to view the help from
the Microsoft Visual Basic window (which you can display by pressing
Alt+F11) to see the help topic for this function.

Perfect! Thanks!

As a followup - is there a page somewhere that details all the many and

varied uses of the Format function?