Adding fields in a subform

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

Guest

I have a database where each record has fields where I can enter amounts.
That is, on my main form, there is a subform. On the subform, I have fields
such as entrance fee, permit fee, pin fee, etc... I want to be able to
total these fees in a field on the subform for each record. Therefore, no
matter what record I access, I can see the amounts and different fees, plus
the total of the fees. I was thinking that maybe I could use a query, but
need some help.
Does anyone know how can I do this?
Any assistance would be greatly appreciated.
Thanks in advance.
 
In the query, add in all the fee fields. In the next available column do

=[Pin Fee] + [entrance fee] + . .. .. .

Note: If any of these are null, you'll have to do some sort of Null To Zero
.. .
 
Back
Top