Re: Error Message on Calculation

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: JulieD (julied_ng_at_hctsReMoVeThIs.net.au)
Date: 03/11/04 

Date: Fri, 12 Mar 2004 00:34:55 +0800

Hi Sherry

I think the problem might be that Tax is a calculated field based on an IIF
statement ..
i'm not sure of the best way around this - personally i'ld be tempted to
store Tax in the underlying table ... but there's others on this ng far more
qualified to comment on this matter

so i think i'll just stand aside ...

good luck with the DB
Cheers
JulieD

"JulieD" <julied_ng@hctsReMoVeThIs.net.au> wrote in message
news:udfUXT4BEHA.3524@TK2MSFTNGP10.phx.gbl...
> Hi Sherry
>
> have you got spaces in your =sum([cost]+[tax]) fields?
> is the default value of the tax field 0 or null?
>
> Cheers
> Julie
>
> "Sherry" <sakins@floydboe.net> wrote in message
> news:b13001c40784$5bdeebb0$a501280a@phx.gbl...
> > Using =sum ( [cost]+[tax]) does not work either. Sigh.
> > About to pull my hair out here. I am wondering if it has
> > anything to do with the fact that the Tax field is a
> > formula in itself, in that, I have a Yes/No field
> > ("Taxable?") that I have written an IF statement in the
> > Tax field referencing that answer. The Statement reads as
> > follows: "IIf ([Taxable?]=Yes, [Cost]*.07, 0), saying
> > that if the box for Yes is checked, it will calculate the
> > tax and put the amount in the tax field, but if it is not
> > checked, it will leave the tax field 0.
> >
> > Then I have the Total field which adds together the Cost
> > and Tax fields. "[Cost]+[Tax].
> >
> > I tried summing both [Total] and [Cost]+[Tax] with the
> > same results. I am using Access 2002, if that makes any
> > difference.
> >
> > Thanks,
> > Sherry
> > >-----Original Message-----
> > >Hi Sherry
> > >
> > >it's easier on everyone if you keep your replies in your
> > original thread ...
> > >
> > >the problem is that in the footer of the subform you need
> > to repeat the
> > >calculation that gives you total not just reference total
> > >
> > >try
> > >=sum([cost]+[tax])
> > >
> > >Cheers
> > >JulieD
> > >
> > >"Sherry" <sakins@floydboe.net> wrote in message
> > >news:aeb801c40779$69281bd0$a301280a@phx.gbl...
> > >> Thanks Julie, but that's what I've been trying to do
> > with
> > >> not good results. The field on the subform that I am
> > >> trying to sum is the "Total" field. This field itself
> > is a
> > >> calculated field from 2 other fields (Cost and Tax added
> > >> together). In the footer of the subform I added the
> > >> following control: =sum ( [Total] ) . This returns an
> > >> error. Can you see what I might be doing wrong?
> > >>
> > >> I thought I would probably have to make the calculation
> > on
> > >> the subform then link it to the main form, but I can't
> > >> seem to get past getting the calc correct on the
> > subform.
> > >>
> > >> Thanks for any help you can offer!
> > >> Sherry
> > >
> > >
> > >.
> > >
>
>

Relevant Pages

  • Re: Attention Californians! Veterinary tax proposed!
    ... Sherry wrote: ... from it is earmarked for a specific purpose. ... this tax? ... but not for animal rescue or anything of that nature. ...
    (rec.pets.cats.anecdotes)
  • Re: Calculations in Tables
    ... Calculated field should not be stored (even in ... But the tax as missinglink rightly says may change. ... The deed is done and the transaction stored. ... If the calculations are stored, ...
    (microsoft.public.access.gettingstarted)