Totalling Columns

[Chris]

Is there any way to total columns in an access query
without analyzing it with excel?

Thank you

 

[Rick Brandt]

Is there any way to total columns in an access query
without analyzing it with excel?

Add a calculated field to the query.

TotalCol: Field1 + Field2 + Field3

 

[Guest]

Joe, thanks- exactly what i needed!
CM

-----Original Message-----

Is there any way to total columns in an access query
without analyzing it with excel?

No and yes. In the query itself, no; but it's a simple matter to create a
report based on the query and gereate the sums in the report footer. Insert
a text box in the footer & set the data source to =Sum ([FieldName]).

Joe F.


.