Professional Web Applications Themes

Percentages - Microsoft Access

I have a field that needs to be a percentage, when I enter 35 it changes to 3500%, if I enter .35 it shows as 0%. I just need it to show as and be entered as 35 to be 35% Can someone help......

  1. #1

    Default Percentages


    I have a field that needs to be a percentage, when I enter
    35 it changes to 3500%, if I enter .35 it shows as 0%.

    I just need it to show as and be entered as 35 to be 35%


    Can someone help...
    Gianna Guest

  2. #2

    Default Re: Percentages

    Matt,

    In the 'table design view' you need to change the "Field Size" of your field
    to either single or double depending on your need. Then you can enter your
    percentage values in decimal form (0.20 = 20%).

    I suspect that it currently says "Long Integer". Remember an integer is a
    "whole number" e.g. 1, 2, 300, -976. A decimal is NOT an integer -- and
    thus neither is a decimal.

    Sean

    "Gianna" <gianna.wrightigt.com> wrote in message
    news:018301c34007$89bbf090$a501280aphx.gbl...
    >
    > I have a field that needs to be a percentage, when I enter
    > 35 it changes to 3500%, if I enter .35 it shows as 0%.
    >
    > I just need it to show as and be entered as 35 to be 35%
    >
    >
    > Can someone help...

    Sean Guest

Similar Threads

  1. Calculate Ink Percentages in Acrobat Professional
    By tim_zurko@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 2
    Last Post: November 6th, 02:35 AM
  2. Specifying Width and Height properties as percentages
    By Nathan Sokalski in forum ASP.NET Building Controls
    Replies: 2
    Last Post: June 15th, 03:36 AM
  3. percentages in mx
    By Moggie webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 2
    Last Post: January 13th, 03:10 PM
  4. onstat -P buffer percentages
    By Glen Johnson in forum Informix
    Replies: 3
    Last Post: November 17th, 01:25 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139