Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Percent Rounding (2kProSR1a)

    Sorry folks ... I know this has been previously asked and answered but I can't find it.

    The simple question is: What do I have to do in formatting a percent field to get it to display as entered? Entering ".75" or ".25" results in displays of 100% and 0%. I've tried standard/2 places*100; percent 2 places; percent 4 places with no luck. What's the trick (beyond making it a text field which is admitting defeat)?

    Sorry for the "Senior Moment", but I'm stuck.

    Thanks much

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Percent Rounding (2kProSR1a)

    Just a guess but try checking your fields data type in the table. An Interger type will always show whole numbers, you want a double.

    HTH

    Peter

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Percent Rounding (2kProSR1a)

    First of all, *where* are you trying to display it? Is this in a form, a table, a query, a report or what? Second, what type of number did you select for the underlying field, assuming this is in a table or query? You'll can select as single or a double, but I would recommend chosing Currency as your datatype if you want no more than 2 decimal places. The Currency format will hold 4 decimals, so you can represent decimal fractions up to n.99% using the currency format and you won't have the floating point issues to deal with if you need to do calculations with the values.
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Percent Rounding (2kProSR1a)

    Peter:

    You're absolutely correct. I forgot about the "double" formatting, then kicked myself when you reminded me.

    Thanks again,

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Percent Rounding (2kProSR1a)

    Charlotte:

    Thanks for the response.

    Peter's response jogged my memory and solved the problem.

Posting Permissions

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