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

  • Thread starter Thread starter Liat
  • Start date Start date
L

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
 
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
Click to expand...


.
Click to expand...
 
Back
Top