Summing a subreport on a form.

[Christopherusly]

I have a subreport [qry_projectviewsummary subform] on Form [tbl_projectdetails], I have created the following expression in the footer of the subreport =Sum([Cost]) which provides a SUM of the Cost fields of the subreport.

When i reference this in the form, as such:

=[qry_projectviewsummary subform].[ Form]![Sumofcost] all i get is NAME?

the name of the control which SUMS cost is Sumofcost, what am i doing wrong ?

Thanks guys.

Chris

 

[Christopherusly]

Solved, the problem was the " " i had in [ form]

thanks anyway

 

[vbaInet]

Goodie!!!