Help with calculations

  • Thread starter Thread starter Maria
  • Start date Start date
M

Maria

I have a simple question, but no one seems to be able to
help me. I want to create a table with income from
various different sources. At the bottom of the column of
figures, I want to put a "Total" which will add up the
previous fields. This can be right in the table or in a
query. Either way, someone please tell me how to do it.
Thank you very much for your time.
 
Maria said:
I have a simple question, but no one seems to be able to
help me. I want to create a table with income from
various different sources. At the bottom of the column of
figures, I want to put a "Total" which will add up the
previous fields. This can be right in the table or in a
query. Either way, someone please tell me how to do it.
Thank you very much for your time.
Click to expand...

Neither tables nor queries in Access (or most any other database) have
"totals at the bottom" capability. That is how spreadsheets work, not
databases. You need to build a report or a form for this.
 
I have a simple question, but no one seems to be able to
help me. I want to create a table with income from
various different sources. At the bottom of the column of
figures, I want to put a "Total" which will add up the
previous fields. This can be right in the table or in a
query. Either way, someone please tell me how to do it.
Thank you very much for your time.
Click to expand...

Use a Form (for onscreen viewing) or a Report (for printing).

You cannot do this in a table or a query datasheet (well, you could in
a query but it would be UGLY and inappropriate). Instead, in the Form
or Report Footer put a textbox with a Control Source of

=Sum([fieldname])

Use the tools that Access provides. It's not necessary to do something
in a difficult way when an easy way is provided!
 
Back
Top