DAvg()

[Bobby1st]

DAvg () shows Blank instead 0 when there's no data

Gentlemen:

I have a YTD employee data report, from Jan 2008, I added a new category called Flexible Tasks, previous to that date it default to zero. I used DAvg () to get the average total, however if there is zero data for 2008, the formula returns blank. I like it to return "0". The formula is =Avg([flexible]),DAvg("[Flexible]","qryEE YTD Rollup","[Flexible]>0"). The problem with a blank result, it can't be use in addition, if the formula is [22]+[44]+[33] = it will give out a blank.

I tried these formulas and still return blank.
=IIf(DAvg("[Flexible]","qryEE YTD Rollup","[Flexible]>0")=0,Avg([flexible]),DAvg("[Flexible]","qryEE YTD Rollup","[Flexible]>0"))

=IIf(DAvg("[Flexible]","qryEE YTD Rollup","[Flexible]>0")="",0,DAvg("[Flexible]","qryEE YTD Rollup","[Flexible]>0"))

Can you help?

Thanks