Sumary in reports

[Vallan]

Hi.

I need a simple help with sumary in a report.

My problem is this..... I have a weekly report that shows products we have sold and products we have bought.


When a sum these i get the total of outgoing and incoming in that week i have choosen.

But some weeks we dont buy anything, just sell. That makes the buy sumary to become "wrong" because there are nothing to sum...."Empty".


Can anyone help me to explain the easiest way to do so that i can get a 0 if its empty?

I hope you understand my problem and sorry if my english isnt so good!


MC

 

[ted.martin]

Try putting the control source
= nz(Sum([Lines]))
This forces a zero from a null and hopefully should do the trick.

 

[Vallan]

Thank you

But i have already tried that one.


It helps if you have posts in that week.


But not if you dont have any posts in that specific week.


Then the subreport are empty.......nothings at all.

In my mind i think like this. If [total] = empty then [total],0

But i know its not correct thats why i try to ask if you have any suggestions.

MC