Adding fields from separate subreports

[brandon]

Hello all,

I am trying to add three Cost fields from three seperate
subreports. This works just fine when all three
subreports have data in them. However, when one
subreport does not have any results, the Grand Total
field that adds the three totals shows Error. This makes
sense since one of the total fields is non existent. Is
there any way to force that field to zero if that
subreport does not come back with any data?

Am using Access 2000.

Thanks in advance.

Brandon

 

[debbie-]

I am no expert, but I would think that you could set that
field to zero in the NoData event of the subreport.