Calculated Field

[rosscortb]

Hello,



If I have 4 fields, A,B,C,D

and in column 5 I have a calculated field adding the total of the 4 columns, [A]+[B]+[C]+[D], works fine, but if there is no cost in say column C, it woudn't add so do I need an if statement, not sure on this. Dummy's guide would be appreciated.

Thanks

Ross

[JoeM]

Use the NZ function to handle null values, i.e.

NZ([A],0)+NZ([B],0)+NZ([C],0)+NZ([D],0)

See this for more on the NZ function: http://www.techonthenet.com/access/f...dvanced/nz.php

[ssanfu]

Note: having/using calculated fields in a table is not a good idea. Since it is calculated, it can be calculated at any time.

Read this page carefully. Read it at least twice, especially the last two paragraphs.
http://allenbrowne.com/casu-14.html

[theyad75]

make new query design add all the column of the table then in next column write total:NZ([A],0)+NZ([B],0)+NZ([C],0)+NZ([D],0)

if u want another column for classifcations result tell me

[JoeM]

My original reply was geared towards a Query solution, like theyad75 shows how to implement my solution in a query. I don't know if you were trying to do the calculation in a table, but if so, I wholeheartedly agree with Steve.

[theyad75]

Yes for Sure JoeM your Answer is the core part of the solution