Help

[Juan F Mena]

I have the following code on a calculated control =([AlumnosIQ.englishFin]+[AlumnosIIQ.englishFin])/2 It works fine, but when it finds a null value does not show any result. What I want is that the formula proceed with only one of the data values ignoring the null value. Does it make sense? Can somebody help?

EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx

 

[Linq Adams via AccessMonster.com]

You need to replace the Null value with zero, using the Nz() function:

= (Nz([AlumnosIQ.englishFin], 0) +Nz([AlumnosIIQ.englishFin], 0))/2

FYI, you can also use Nz() to replace a Null Text value with a string, like

Nz(strType, "N/A")

so if a "type" isn't appropriate, and is left blank, N/A will appear.