calculate form control if one of them is blank

  • Thread starter Thread starter robertm600635
  • Start date Start date
R

robertm600635

I have a report that has two subreports. On each subreport is a calculated
field. On the main report I have a textbox that adds the two calculated
fields together (basically...[SubReportCalc1]+[SubReportCalc1]). This works
fine unless one of the subreport fields are blank, this happens when there
was nothing to calculate. How can i get it to still calculate on the main
report correctly?
 
That was exactly what I needed...thank you.

Allen Browne said:
See:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

The article shows how to use the HasData property of the subreport to avoid
the error if the subreport has no data.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


robertm600635 said:
I have a report that has two subreports. On each subreport is a calculated
field. On the main report I have a textbox that adds the two calculated
fields together (basically...[SubReportCalc1]+[SubReportCalc1]). This
works
fine unless one of the subreport fields are blank, this happens when there
was nothing to calculate. How can i get it to still calculate on the main
report correctly?
Click to expand...

.
Click to expand...
 
Back
Top