Formatting Percentages....HELP

Results 1 to 2 of 2

Thread: Formatting Percentages....HELP

  1. #1
    Join Date
    Dec 1969

    Default Formatting Percentages....HELP

    I&#039m using Access as my DBMS, and am having a problem. I want to use percentages, and in the queries the percentages are just fine, but then when I write them to the screen they come up as decimals and to about 8 or 9 decimal places. Is there a way of formatting the percentages to make them to one decimal place and not as decimals? For example, when it has 50% it writes to the screen as 0.5 If soembody could help me out that would be great.

  2. #2
    Howie Guest

    Default RE: Formatting Percentages....HELP

    You can use this VBScript Function:<BR><BR>FormatPercent(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts