[AccessD] Having trouble with a percent column`

Ryan W wrwehler at gmail.com
Fri Apr 7 15:13:05 CDT 2023


Rich Ross recently did a video on the Access Percentages and how to remedy
some of the oddities.


On Fri, Apr 7, 2023 at 2:18 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> Percent is the Format. Make the Type of that field Number and the Field
> Size should be Double or maybe Single but floating point in any event.  You
> would then enter percentages as a decimal fraction and in your table it
> will show as a percent. For example, enter .1 and it will display as
> 10.00%.
>
> HTH
>
> r
>
> On Fri, Apr 7, 2023 at 10:48 AM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > I defined a column in a table called Percentage and set its type to
> > Percent. No matter what I enter, it always displays zero. What am I doing
> > wrong?
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list