Missing Zero - Please Help!!!!!!!!!!

[midiman69]

Hi

I have a report with four text boxes displaying subform totals.

One of them refuses to display zero if no data

=IIf([Reports]![rpprojects]![qrybom subreport].[Report].[HasData]=True,[Reports]![rpprojects]![qrybom subreport].[Report]![sumadjustcost],0)

The others work fine using a similar format

=IIf(Reports!rpprojects![qrybom subreport].Report.HasData=True,Reports!rpprojects![qrybom subreport].Report!totalsk/Reports!rpprojects!rpqryrates.Report!exrate,0)

All all formatted as Curency, 4 decimals.

Can any one help with this - I can't see anything wrong!!

Cheers

Dave

 

[Remou]

Is it possible that the control you are referencing is null? In other words, if the sub report has data but the summed field is null, you will not get a zero.

 

[midiman69]

Dohhhhhhhh,

Thanks Remou

=Nz(Sum([Adjustprice]*[qty]),0)

Cured the problem

Cheers

Dave