If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add several number fields up in a total field
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/For...forms/201004/1 |
#2
|
|||
|
|||
Add several number fields up in a total field
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/For...forms/201004/1 . |
Thread Tools | |
Display Modes | |
|
|