Access 2000

E

Emma

We have set up a query which produces rows and columns, how do we go about
showing a total of a particular column?
 
R

Rick Brandt

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.
 
Top