Search results

I have fields in a subform that add the contents of other fields. These fields are placed in the footer and I have fields in the main form linking to them. I have changed the name of some of the main fields in the subform and now I can not get the fields adding these fields up to work, even...

Hi, Have you put the query field as the control source for the field in the form? Tariq

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

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

Thanks, I'll give that a try. Tariq

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