Column Totals in Query

  • Thread starter Thread starter PawleysGrits
  • Start date Start date
P

PawleysGrits

Can you please tell me the quickest/easiest way to add up a column of
figures, and print it at the end of a query? Sorry to be so thick on this
issue, but it is NOT coming together for me.

And thanks, you MVPs for your service to this community of dummies!
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SELECT SUM(column_name)
FROM table_name
WHERE < criteria >

The SUM() column will not have a final sum at the bottom of the column.
JET SQL doesn't do that. If you want that, use the query as the
RecordSource of a Report and put a sum TextBox at the bottom of the
column. Hint:

ControlSource: =Sum(column_name)

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQfU8roechKqOuFEgEQKapgCfZyeL1PWw61eBtiEOr/LEIrKeKdkAn1mf
ZIaWY9Y0R24KUbJAjJv8GDk5
=eEJu
-----END PGP SIGNATURE-----
 
Back
Top