Null Value & DAvg (1 Viewer)

[LED]

Hello,

I have a table that I need to run DAvg on for each column. It works on the first column that does not have any Null values, but I get a data type mismatch error on the second column that contains Null values. According to the help file, DAvg should be able to handle Null values.

Any ideas on how to get this to work?

Thanks!

 

[MStef]

Hello LED!

I suggest to make an UPDATE QUERY,
and update all NULL VALUES in 0.

 

[Johny]

You can also filter out the null values of that field if you specify it in the criteria parameter

btw LED from BooZZe?

 

[gemma-the-husky]

if you don't want to set the null values, then base yuor summary on a query, in which case you can change the nulls by setting the column to nz(myfield,0)

depends whether you want to include the nulls in the average or not

 

[Pat Hartman]

If you're getting a type mismatch, the column is probably not numeric. Nulls do not present a problem for domain functions. They are simply ignored. For example the average of 2,4,null is 3 but the average of 2,4,0 is 2.