using Nz function in a field

[danieltaylor]

Hi to all,


I have a Nz function in my data entry form and i put it to an unbound text field to sum the values from 5 fields, now i want that value (the result of the Nz function) to be stored on my table. how can i do this??? any help pls...

[orange]

More info please. Can you give us an example of what you are doing?

[RuralGuy]

Maybe this link will help: http://allenbrowne.com/casu-14.html

[danieltaylor]

well it goes like this: there a 5 fields that i want to add [1], [2], [3], [4], [5] in my table, and [6] will store the result. but there times that 1 or more fileds will be empty/null so in my data entry form i used the function: Nz([1],0)+Nz([2],0)+Nz([3],0)+Nz([4],0)+Nz([5],0) which i put on unbound field, now i want to store its result to [6] in my table, or is there any other way sum fields in which some are empty that the result will be stored on the table...
thanks....

[orange]

You don't store calculated fields in a table. You Normalize your table(s). You have "atomic" fields [single value/single purpose] in your Table. You do calculations (Sums etc) in queries if and when you need the calculated values.

So consider Table1 with fields f1, f2 , f3, f4, f5. To calculate the Sum for those fields in that record in that table
MySum:Nz(f1,0) + Nz(f2,0) + Nz(f3,0) +Nz(f4,0) +Nz(f5,0)

Relational database principles see http://forums.aspfree.com/attachment...2&d=1201055452
More info on Nz at http://www.techonthenet.com/access/f...dvanced/nz.php