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
If you feel this answer has been useful please check the "was this post
helpful" so I get some feedback. Thanks.
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9771-working-with-percent-in-table.html
> > helpful" so I get some feedback. Thanks.
> > "teelee" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9771
> > > 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%.