Gary Kjos
garykjos at gmail.com
Wed Oct 25 13:57:29 CDT 2006
If you bring up the properties for that column you will see a format
and number of decimals property you can set for the column. To see the
properties of the column, RIGHT click on the very very top of that
column in design view grid.
GK
On 10/25/06, Hollis, Virginia <hollisvj at pgdp.usec.com> wrote:
> Thanks! Last question...
>
> The Average shows like: 0.0909090909090909 how can I get it to show
> without all the numbers - like round it?
>
> DaysClose: DateDiff("d",[opendate],[clsddate])
>
>
> Click on the "Group By" button. Set the person information to "Group
> By"
> and set the calculated column to "Average".
>
> Doris Manning
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
Gary Kjos
garykjos at gmail.com