Summing Columns in a CrossTab Query 1

[grouch]

Am trying, unsucessfully, to sum the columns in a report that is using a crosstab query as the data source. Any advice would be most appreciated.

 

[fredk]

Hi - I just put together a crosstab query as a sample and the wizard puts in the column totals - if the value that you are totalling is FIELDA it looks like this:

Field TotalofFIELDA: FieldA
Table yourtable
Total Sum
Crosstab Row Heading

hope that helps

Fred

 

[grouch]

FredK-
Appreciate your input. Attempted to redo with the wizard but am using 2 tables and a parameter query as source data; which the wizard will not allow. I was able to create Totals by the ROW, but still unable to get Totals by the COLUMN. The problem seems to be that I do not have any real "fields" for the column data since they are generated with each report execution. Any other thoughts??

Thanks.

 

[fredk]

Can you first bring all of the data together with a seperate query and then base the crosstab from this new query?

Fred

 

[J3fer]

Just beating my head over this issue and my problem was solved when I bumped into this FAQ:

http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/27/pid/703/fid/2868

When I ran the Wizard, I then peeked at how IT set up the row totals and then inserted this into my existent crosstab query (which is attempting to sum volunteer hours which are broken down by month)

In your query, insert a new field anywhere, with the following parameters:
- Field: TotalHours: intHours
- Table: Timesheets
- Total: Sum
- Crosstab: Row Heading

This seems to have done the trick for me; let me know if it works for you!

 

[fredk]

Yes, that was what I was getting at - Glad you got it to work!!!!

Fred