Format Function - Percent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try:

Format([COLUMN], "0.0%")

MDW said:
Hey all,

When I use the Format([COLUMN],"Percent") syntax in a query, the result is
Click to expand...
in the desired format, but it has 2 places after the decimal point. Any way
to specify if I only want 1?
 
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.

MDW said:
Perfect! Thanks!

As a followup - is there a page somewhere that details all the many and
Click to expand...
varied uses of the Format function?
 
Back
Top