crosstab query total column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I make a total column ( sum ) on a crosstab query

TRANSFORM Sum([SumOfMOV]
SELECT [DESCR], Sum([SumOfMOV]) AS [Total Of SumOfMOV
FROM [TABLE
GROUP BY [DESCR
PIVOT Format([RPDGJ],"mmm") IN ("Jan","Feb","Mar","Apr","May","Jun","Jul","Agu","Sep","Oct","Nov","Dec")

I want to add at the end of each row a total column... adding each of the values on each month...
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Run the query & drag the column heading [Total of SumOfMov] to the
last column on the right of the display grid. Save the query. When
next run the Total of SumOfMov will be at the extreme right of the
display grid.

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

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

iQA/AwUBQE0EGIechKqOuFEgEQIaIACdHwgD/L05cPrg2Qze+Y+VlCfxA1oAoL+/
K94LLj+s4TwyQd5sbbIlTJUR
=6/XL
-----END PGP SIGNATURE-----
 
Back
Top