Access 2000

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

Guest

We have set up a query which produces rows and columns, how do we go about
showing a total of a particular column?
 
Emma said:
We have set up a query which produces rows and columns, how do we go
about showing a total of a particular column?
Click to expand...

Use a report. A query can return your columns or the sum of your columns,
but not both at the same time. If you base a report on your query you can
use...

=Sum([FieldName])

....in either the Report Header or Footer and it will give you that result.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selection of records from subform to lock and further processing in access 2007 0
How do I automatically create lists from column topics in a chart 0
MS Access & Citrix - query design form problems 6
reporting even though a calculation made is dividing by zero 14
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Crosstab Query Results 3
Curve fitting with weighted trendline 1
Sorting a query 17

Back
Top