sum of column information

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
 
J

John Spencer (MVP)

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
 
Top