Decimal places in calculated field

Re: Decimal places in calculated field

Try setting the Format to Fixed instead of General.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<paulquinlan100 @hotmail.com> wrote in message
news:1149602409 .648265.124800@ i40g2000cwc.goo glegroups.com.. .[color=blue]
> Hi
>
> I have a couple of calculated fields in a report, i've set the Decimal
> Places property to 0 and the format to General Number, however when
> previewing the report it still comes up with a number with up to 8
> decimal places!
>
> Any suggestions how to overcome this problem gratefully received!
> Paul[/color]

Re: Decimal places in calculated field

Thanks Allen

It really was that easy...

Paul


Allen Browne wrote:
[color=blue]
> Try setting the Format to Fixed instead of General.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> <paulquinlan100 @hotmail.com> wrote in message
> news:1149602409 .648265.124800@ i40g2000cwc.goo glegroups.com.. .[color=green]
> > Hi
> >
> > I have a couple of calculated fields in a report, i've set the Decimal
> > Places property to 0 and the format to General Number, however when
> > previewing the report it still comes up with a number with up to 8
> > decimal places!
> >
> > Any suggestions how to overcome this problem gratefully received!
> > Paul[/color][/color]

Re: Decimal places in calculated field

On 6 Jun 2006 07:00:09 -0700, paulquinlan100@ hotmail.com wrote:
[color=blue]
> Hi
>
> I have a couple of calculated fields in a report, i've set the Decimal
> Places property to 0 and the format to General Number, however when
> previewing the report it still comes up with a number with up to 8
> decimal places!
>
> Any suggestions how to overcome this problem gratefully received!
> Paul[/color]

You don't want to see any decimals?
Set the Format property to Fixed (NOT General Number)
Set the Decimal Places property to 0.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail