Add several number fields up in a total field
in [Form]
|
From: PieterLinden via AccessMonster.com on 6 Apr 2010 01:41 joe90 wrote: >Hello, > >I have a form that tracks progression on a number of student qualifications. > >There are 8 number fields that represent the percentage complete on eac >qualification, and all I want to do is to add all 8 fields together to get >total progression in a total field. > >I am transferring this from excel, and this is easy to do in excel, but I can' >get it to work. I basically add all fields then divide by 8. I am trying to us >the expression builder. > >Thanks in advance. Just use an unbound control on your form and set the controlsource to = [Control1] + [Control2]... + [Control8] It won't get stored anywhere, but it's a derived value.. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1
From: KARL DEWEY on 6 Apr 2010 14:06 If any field may have a null then this way -- = Nz([Control1], 0) + Nz([Control2], 0)... + Nz([Control8], 0) -- Build a little, test a little. "PieterLinden via AccessMonster.com" wrote: > joe90 wrote: > >Hello, > > > >I have a form that tracks progression on a number of student qualifications. > > > >There are 8 number fields that represent the percentage complete on eac > >qualification, and all I want to do is to add all 8 fields together to get > >total progression in a total field. > > > >I am transferring this from excel, and this is easy to do in excel, but I can' > >get it to work. I basically add all fields then divide by 8. I am trying to us > >the expression builder. > > > >Thanks in advance. > > Just use an unbound control on your form and set the controlsource to > = [Control1] + [Control2]... + [Control8] > > It won't get stored anywhere, but it's a derived value.. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1 > > . >
|
Pages: 1 Prev: Moving Subform to Tab Control Next: I can't add users to my database. |