Urgent Help!!!

[Neilw]

I need a currency field in a form to equal the sum of all entries in a subform. Is it possible to automate this or will the user have to work this out and type it manually?

(By the way this is in Access 2000)

[This message has been edited by Neilw (edited 03-13-2002).]

 

[sandhurstUK]

Try adding a field into the footer of the subform and set the source as:
=sum[field name containing data to be calculated]. It works in my forms.