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

Kamis, 25 Oktober 2012

[AccessDevelopers] Re: Help with calculated field on form

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, 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
> 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, "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, "Ted S" <miamited33156@> wrote:
> > >
> > > I have uploaded the access file in a folder named Ted.
> > >
> > > --- In AccessDevelopers@yahoogroups.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, "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.
> > > > >
> > > >
> > >
> >
>