total subform on mainform

[rschultz]

I have a textbox on a mainForm called TotalTime in which I'd like to sum the total of the [Time Spent]textbox on all the subForm records, but just for the ID # of the mainForm. I tried: =Sum([Sub Table].[Time Spent]) (afraid that I would get the total for the entire table, not just that ID#) but instead I get #name? Anyone know how to do this?

 

[Jack Cowley]

See if this article answers your question:

http://support.microsoft.com/support/kb/articles/Q208/9/98.asp

 

[rschultz]

perfect! thanks a lot

 

[rschultz]

okay, sorry. I had, I thought, a valid reason but I won't waste time with that. The solution you gave me doesn't appear to work with Reports. I tried:

=[Sub Table Subform].[Form]![text14]

on a Form, which works great but:

=([Sub Table Subreport].[Report]![text16])

on a report doesn't work.

 

[rschultz]

fixed it. I had the summing control on the subReport in the Page Footer, not the Report Footer.

Thanks anyway