Subform Calculations

[claddagh]

Hiya Guys,

Just like to thank you all for all the previous help I have recieved from this forum.

I have reached another snag

I am trying to show a field in a form which will be the sum of some data in a sub form ( Which hols data in a seperate table )

Anyway,

The Relationshiop to the subform table is a 1-many from my main table.
This has a ref number which is what makes the 2 link together.

Im trying to find the money value of feild X all of the records related to the reference number, then this needs to be displayed in a query so I can show this value in a form.

This is what I`ve tried and it just displayer #error =Sum([Cost £])
I would have though this would work, as i have used this before to calculate the running total of another field. Does this not work because its a subform im trying to get the data from ?

I`ve attached a copy of the database with some sample data in it just incase I have not made myself clear. (A2003)

Thanks in advance for any help/advice.

Max

[update]

Quote:
In the report, do the SUM in the subreport, set it to 'Invisible' (in the properties box), and reference it in the the main report by adding an unbound text field and setting its Control Source to: =Name_Of_Your_Sub_Report.Report!Name_of_the_Invisible_Totals_Textbox

I have done the above, but made changes like below:
=[Materials & Labour subform]!Total

But the field the data is blank.

Im at a total loss as to why this is happening.

Any & All Help Is Appreciated.

Thanks in advance
Max

 

[claddagh]

Thanks

Thanks for the responce.
It helped.

I also noticed I miss read some of the previous posts.

I missed out the ".report" part.

Once I included that, it all worked a treat.

This really is a great forum, and all your help is well appreciated !!

Max