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-----
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UNION and Crosstab query 5
Crosstab qry not adding up 1
Showing Crosstab Totals Column in Chart 1
Group by Range in Crosstab Query 4
Crosstab returns blank fields 6
Custom Format for crosstab headings 2
Crosstab, Quarter Sum isn't working 6
Crosstab Returns Empty Fields 2

Back
Top