Creating a sum of a single subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings!

I have what may be a very simple question. Unfortunately, I haven't worked
in Access in several years and am now lost!

I am "updating" someone else's database - from a very simple level to one
designed to make life easier.

My main form is client information. One of it's subforms is regarding
flight information for each client. We track all the flight data as well as
the dollar amount of the ticket. There are 3 fields for the dollar amounts -
Company Paid, Reimbursed and Total Paid

What I am trying to do is have the Total field add up the Company Paid &
Reimbursed field for each subform. Currently the Total is manually entered
and manually added - too many places for human error here!! When I create a
simple =Sum(...) it sums up all 14000 of my records and only displays
randomly.

I hope this makes sense!

Thanks
Stacey
 
I assume that the subform is filtering based on the LinkChildFields and
LinkMasterFields properties of the subform object, right?

Easiest way to do this is to use a DSum expression in the control source of
the textbox that will show the sum, and include the filtering fields in the
DSum's Where argument. Assuming that you're linking the subform to main form
using a ClientID field:

=DSum("[Company Paid]+[Reimbursed]","NameOfTable","ClientID=" & [ClientID])
 
Back
Top