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.