Avoiding "#Error" fields of calculation when the report is empty

[Liat]

Hello,
I would like to avoid having empty lines in my report
when there are no records following the conditions of the
query. Also, the total sum of the report is currently
#Error when the report is empty.

How can I fix that?

Thanks a lot,
Liat

 

[Duane Hookom]

Use control sources like:
=IIf(HasData,Sum([Qty]),0)

 

[Liat]

Thank you very much!!

-----Original Message-----
Use control sources like:
=IIf(HasData,Sum([Qty]),0)

--
Duane Hookom
MS Access MVP

Hello,
I would like to avoid having empty lines in my report
when there are no records following the conditions of the
query. Also, the total sum of the report is currently
#Error when the report is empty.

How can I fix that?

Thanks a lot,
Liat

.