Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Working with percent in table

Discussion in 'Information Technology' started by teelee, Jul 28, 2006.

  1. teelee

    teelee
    Expand Collapse
    Guest

    Does anyone know how to use the percent in the table? I have a table that has
    a field for a percent, when I enter the number it sould be a percent, in
    which it does the only thing is it has more numbers then I need for example I
    enter 25 and the field shows 2500%.
     
  2. Loading...

    Similar Threads Forum Date
    Working with Christians #3 Blogs Oct 17, 2015
    Working with Christians #2 Blogs Oct 17, 2015
    Working With Muslims Blogs Oct 17, 2015
    Working with Christians Blogs Oct 17, 2015
    USA Working Mother, Washington Powerhouse? Good Luck. Breaking News Aug 2, 2014

  3. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    ([FieldName]/100) then format as percentage


    --
    Wayne

    If you feel this answer has been useful please check the "was this post
    helpful" so I get some feedback. Thanks.



    "teelee" wrote:

    > Does anyone know how to use the percent in the table? I have a table that has
    > a field for a percent, when I enter the number it sould be a percent, in
    > which it does the only thing is it has more numbers then I need for example I
    > enter 25 and the field shows 2500%.
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    An almost identical question was asked this morning. Please search before
    posting a new thread.

    Please go read the thread added this morning at 6:57 AM with the subject
    "...format a cell to percent..."



    --
    Rick B



    "teelee" <teelee@discussions.microsoft.com> wrote in message
    news:3CD2201B-1117-4EF7-9FAD-7DB60C67A7F7@microsoft.com...
    > Does anyone know how to use the percent in the table? I have a table that
    > has
    > a field for a percent, when I enter the number it sould be a percent, in
    > which it does the only thing is it has more numbers then I need for
    > example I
    > enter 25 and the field shows 2500%.
     
  5. teelee

    teelee
    Expand Collapse
    Guest

    Where do I enter this info?

    "Wayne-in-Manchester" wrote:

    > ([FieldName]/100) then format as percentage
    >
    >
    > --
    > Wayne
    >
    > If you feel this answer has been useful please check the "was this post
    > helpful" so I get some feedback. Thanks.
    >
    >
    >
    > "teelee" wrote:
    >
    > > Does anyone know how to use the percent in the table? I have a table that has
    > > a field for a percent, when I enter the number it sould be a percent, in
    > > which it does the only thing is it has more numbers then I need for example I
    > > enter 25 and the field shows 2500%.
     
  6. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    You shouldn't really try and store the results of formulas in a table so use
    it in a report or on a form. You only need to the either see the result on a
    form or in a report so only have it when you actually need it.

    Refer to it using an unbound field (I have called the field containing the
    number you want to work with PercentFieild)

    [PercentField]/100 and thats it (use this as the field's control source)

    Hope this helps

    --
    Wayne

    If you feel this answer has been useful please check the "was this post
    helpful" so I get some feedback. Thanks.



    "teelee" wrote:

    > Where do I enter this info?
    >
    > "Wayne-in-Manchester" wrote:
    >
    > > ([FieldName]/100) then format as percentage
    > >
    > >
    > > --
    > > Wayne
    > >
    > > If you feel this answer has been useful please check the "was this post
    > > helpful" so I get some feedback. Thanks.
    > >
    > >
    > >
    > > "teelee" wrote:
    > >
    > > > Does anyone know how to use the percent in the table? I have a table that has
    > > > a field for a percent, when I enter the number it sould be a percent, in
    > > > which it does the only thing is it has more numbers then I need for example I
    > > > enter 25 and the field shows 2500%.
     
  7. teelee

    teelee
    Expand Collapse
    Guest

    Can you tell me please on where on enter this info. Do I click on the ...
    button and enter it as an expression builder?

    "Wayne-in-Manchester" wrote:

    > You shouldn't really try and store the results of formulas in a table so use
    > it in a report or on a form. You only need to the either see the result on a
    > form or in a report so only have it when you actually need it.
    >
    > Refer to it using an unbound field (I have called the field containing the
    > number you want to work with PercentFieild)
    >
    > [PercentField]/100 and thats it (use this as the field's control source)
    >
    > Hope this helps
    >
    > --
    > Wayne
    >
    > If you feel this answer has been useful please check the "was this post
    > helpful" so I get some feedback. Thanks.
    >
    >
    >
    > "teelee" wrote:
    >
    > > Where do I enter this info?
    > >
    > > "Wayne-in-Manchester" wrote:
    > >
    > > > ([FieldName]/100) then format as percentage
    > > >
    > > >
    > > > --
    > > > Wayne
    > > >
    > > > If you feel this answer has been useful please check the "was this post
    > > > helpful" so I get some feedback. Thanks.
    > > >
    > > >
    > > >
    > > > "teelee" wrote:
    > > >
    > > > > Does anyone know how to use the percent in the table? I have a table that has
    > > > > a field for a percent, when I enter the number it sould be a percent, in
    > > > > which it does the only thing is it has more numbers then I need for example I
    > > > > enter 25 and the field shows 2500%.
     
  8. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    Hi Teelee ??

    Sorry for not getting back to you I thought this thread was finished.

    You have a number of basic choices that don't require any great knowledge of
    how access works and it depends on what you want to do as to which one you
    use.

    If you want to change a number that you have inserted into a box into a
    percentage you can use AfterUpdate
    Right click the box (in design view) and open properties and ensure that the
    format is set to Percentage and then click theEvent column. On the
    AfterUpdate section click the ... on the right and click Code builder and
    insert this code

    Private Sub NameOfBox_AfterUpdate()
    NameOfBox = NameOfBox / 100
    End Sub


    An other method you could use would NOT be to change the actual data but
    refer to it in an unbound box.
    To do this creat a new box (in design view) again open Properties and in the
    Data section insert this into the ControlSource section

    [NameOfBox]/100

    For both options you would need to change NameOfBox to the one you have used
    on your form. If you are creating a new box to find/change the name of this
    box click properties and look at the top of the "Other" column.

    Hope all this makes sense

    --
    Wayne




    "teelee" wrote:

    > Can you tell me please on where on enter this info. Do I click on the ...
    > button and enter it as an expression builder?
    >
    > "Wayne-in-Manchester" wrote:
    >
    > > You shouldn't really try and store the results of formulas in a table so use
    > > it in a report or on a form. You only need to the either see the result on a
    > > form or in a report so only have it when you actually need it.
    > >
    > > Refer to it using an unbound field (I have called the field containing the
    > > number you want to work with PercentFieild)
    > >
    > > [PercentField]/100 and thats it (use this as the field's control source)
    > >
    > > Hope this helps
    > >
    > > --
    > > Wayne
    > >
    > > If you feel this answer has been useful please check the "was this post
    > > helpful" so I get some feedback. Thanks.
    > >
    > >
    > >
    > > "teelee" wrote:
    > >
    > > > Where do I enter this info?
    > > >
    > > > "Wayne-in-Manchester" wrote:
    > > >
    > > > > ([FieldName]/100) then format as percentage
    > > > >
    > > > >
    > > > > --
    > > > > Wayne
    > > > >
    > > > > If you feel this answer has been useful please check the "was this post
    > > > > helpful" so I get some feedback. Thanks.
    > > > >
    > > > >
    > > > >
    > > > > "teelee" wrote:
    > > > >
    > > > > > Does anyone know how to use the percent in the table? I have a table that has
    > > > > > a field for a percent, when I enter the number it sould be a percent, in
    > > > > > which it does the only thing is it has more numbers then I need for example I
    > > > > > enter 25 and the field shows 2500%.
     

Share This Page