Totaling selected records only.

I have been attempting to total some fields from
individual records in a table and then display the result
in a text box but have been unable to do so. I have
setup a Query which if run will sum all the records in
the table. I need to find a way to have the Query total
only the records in the table which are associated with
the record which is currently being displayed in the form
(not from the same table). I would really appreciate any
help in getting to grips with this problem.

On Mon, 31 May 2004 15:42:59 -0700, "David"
wrote:

I have been attempting to total some fields from
individual records in a table and then display the result
in a text box but have been unable to do so. I have
setup a Query which if run will sum all the records in
the table. I need to find a way to have the Query total
only the records in the table which are associated with
the record which is currently being displayed in the form
(not from the same table). I would really appreciate any
help in getting to grips with this problem.

Use a criterion of

=Forms!NameOfYourForm!NameOfTheControl

on whatever field constitues this link.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public