ACCESS FEED: RE: [AccessDevelopers] Re: Help with calculated field on form

Kamis, 25 Oktober 2012

RE: [AccessDevelopers] Re: Help with calculated field on form

Search the web on "database normalization".
I expect your issue is that the control name is the name of a field. If so, change the name of the text box to:
"txtExpenseSum"

Duane Hookom
MS Access MVP

________________________________
> From: miamited33156@yahoo.com
>
> Duane,
>
> I did reply to your question earlier stating that they cound either
> have a number or be empty. Maybe it got lost in the message chain.
>
> I don't understand what you mean by unnormalized. I am still in the
> introductory class, so please bear with me.
>
> I tried =Nz([OtherDeductions$],0) + NZ([TowingStorage$] ,0) and still
> get #name?
>
> Thanks
> Ted
> --- In
> AccessDevelopers@yahoogroups.com<mailto:AccessDevelopers%40yahoogroups.com>,
> Duane Hookom <duanehookom@...> wrote:
> >
> > I think I replied earlier that your data structure seems to be
> unnormalized.
> >
> > Are there numbers in all of the fields/text boxes or are some Null/blank?
> >
> > You may need to use something like:
> > =Nz([OtherDeductions$],0) + NZ([TowingStorage$] ,0)
> >
> > Duane Hookom
> > MS Access MVP
> >
> >
> > To:
> AccessDevelopers@yahoogroups.com<mailto:AccessDevelopers%40yahoogroups.com>
> > From: miamited33156@...
> > Date: Wed, 24 Oct 2012 13:07:30 +0000
> > Subject: [AccessDevelopers] Re: Help with calculated field on form
> >
> >
> >
> >
> >
> > I changed the field to an unbound text box. If I put just one of the
> fields, =[OtherDeductions$], that I want to add in the control source,
> it works fine. If I put more than one,
> =[OtherDeductions$]+[TowingStorage$] , I get #Name? displayed in
> calculated field in the form.
> >
> > I am fairly new to Access and taking the intro class now. I will be
> taking the second and third also.
> >
> > --- In
> AccessDevelopers@yahoogroups.com<mailto:AccessDevelopers%40yahoogroups.com>,
> "Ted S" <miamited33156@> wrote:
> > >
> > > I just realized that it would also be good to let you know hat the
> field that need to total the others is "Incorrect Payment Amount"
> > >
> > >
> > > --- In
> AccessDevelopers@yahoogroups.com<mailto:AccessDevelopers%40yahoogroups.com>,
> "Ted S" <miamited33156@> wrote:
> > > >
> > > > I have uploaded the access file in a folder named Ted.
> > > >
> > > > --- In
> AccessDevelopers@yahoogroups.com<mailto:AccessDevelopers%40yahoogroups.com>,
> "ecoorens" <ecoorens@> wrote:
> > > > >
> > > > > Not clear on what you are really trying to do but maybe this
> will help.
> > > > > Assuming you have a form with a table as its source and you are
> trying to sum fields for viewing purposes and you want the sum to
> reflect fields on the record being viewed, then an unbound field on the
> form will give you that...record by record.
> > > > >
> > > > > Someone else has already stated that you do not need to store a
> sum because you can recalculate...that is true.
> > > > >
> > > > > If I have missed what you are trying to do...please give us
> more info.
> > > > >
> > > > > Good Luck! Elaine
> > > > >
> > > > > --- In
> AccessDevelopers@yahoogroups.com<mailto:AccessDevelopers%40yahoogroups.com>,
> "Ted S" <miamited33156@> wrote:
> > > > > >
> > > > > > I have a form that I want a field to add up the numbers that
> may be entered in other fields. There will be 27 when I am finished. I
> am just trying to get it to work with 3 for the time being.
> > > > > >
> > > > > > In control source for the calculated field I have this
> entered =Sum([OtherDeductions$]+[TowingStorage$]+[Salvage$]) there are
> no spaces.
> > > > > >
> > > > > > It calculates the correct amount in the first record, but
> when going to the second record, it still shows the same amount.
> > > > > >
> > > > > > Also, it does not store the amount in the field in the table
> it was created from.
> > > > > >