Need Help Report and Subreport

[March]

Hello All,

I try to figure out a report footer.

For example, I have
1. a textbox to display sum(amount) in (main)report as subTotal.
2. another textbox to display sum(amount) in subreport as another subTotal.
[I get the sum(amount) from Table, using "insert into tb ( ) select
sum(amount) from tempTb;" ---> This can be zero. ]
3. another textbox to display sum(1+2) in (main)report as grandTotal.

My problem is if 2. is zero, in 3. displays "#Error". I would like to insert
0 [zero] in 2., if the tb is empty.

Please give me suggestion. I might be wrong to do this way.

Thanks,
March

 

[March]

I already solved this problem.

Thnaks