Calculation in Query

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

Guest

Hi,
I have created my query table and would like to calculate each field
indvidualy for the total amount in the entire database that is under that
field. Is this possible?
My following Query is as followed:

Repayment Repairs Extra contribution etc... (query is
coming from two table's that is linked)

Therefore I would like to have the "total" cost for any data under
"repayments" to appear in this query etc. My plan is to have all the fields
calculated, so when I create a form, I can have a look at the form at a
glance and it will have all the total's caculated for me in one sheet (like a
summary page).
Any suggestions would be appreciated.
 
Hi,
I have created my query table and would like to calculate each field
indvidualy for the total amount in the entire database that is under that
field. Is this possible?
My following Query is as followed:

Repayment Repairs Extra contribution etc... (query is
coming from two table's that is linked)

Therefore I would like to have the "total" cost for any data under
"repayments" to appear in this query etc. My plan is to have all the fields
calculated, so when I create a form, I can have a look at the form at a
glance and it will have all the total's caculated for me in one sheet (like a
summary page).
Any suggestions would be appreciated.
Click to expand...

The simplest way to do this is to use the Form's Footer; put textboxes
in the Footer with a control source like

=Sum([Repayment])

to sum all of the Repayment values in the Form's recordsource.

John W. Vinson[MVP]
 
Back
Top