calculate form control if one of them is blank

[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?

 

[Allen Browne]

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.

 

[robertm600635]

That was exactly what I needed...thank you.

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.

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?

.