Totaling selected records only.

  • Thread starter Thread starter David
  • Start date Start date
D

David

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.
 
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.
Click to expand...

Use a criterion of

=Forms!NameOfYourForm!NameOfTheControl

on whatever field constitues this link.
 
Back
Top