Hi,
How do I add the contents of a certain field in a subform? For example, if I have sold ten items to someone and I want to add their costs together and display this at the bottom of the form?
Thanks, Tariq

Go to the form Footer of your subform. Add an unbound text box. Set its control source to = sum([yourfieldname])

Thanks, I'll give that a try.

Tariq

Thanks for the help, but when I assign this I get #ERROR in the text box when it ttrys to work it out!!. (The Subform is a subform created from a query)
Please help!!!

Thanks, Tariq

That's strange because it worked on my form. My subform also has the control source as a query. Did you forget the "=" sign? Maybe that would be the problem.

Hi,
I definately had the = sign in, access did keep removing the space between it and the Sum function, would that be the problem?
I am using Access 2000, are you using a different version?
If anyone has any ideas they are welcome.

Thanks, Tariq