sum of column information

  • Thread starter Thread starter pipsqueak
  • Start date Start date
P

pipsqueak

I have a column with numbers in it. I need to calculate a total at the end
of the query for this column but am having great difficulty.

Running Access 2000 on 98.

Anybody have any knoweledge of this?

GOrd
 
You can't do it in one query.

IF you are trying to do this for a report, then it is easy to do in the report.

If you have to do it in query, then the only way I know is to use a union query
where one section does your current query and the second section is a totals
query with "Dummy Fields" for all but the field you want a summary on.
Something like:

Select "" as SetOrder, TextFieldA, TextFieldB, FieldDate, FieldAddThis
FROM YourTable
UNION
SELECT "TOTAL:",Null,Null,Null,Sum(FieldAddThis) as Total
FROM YourTable
ORDER By 1, 4
 
Back
Top