Totaling Columns in Access Crosstab Queries

[erich13us]

This is the query that I have:
TRANSFORM(Count[Client Demographics].CLTCODE AS [THE VALUE]
SELECT [Status Code].Status, Count ClientDemographics].CLTCODE AS TOTAL
FROM [Status Code] INNER JOIN [Gender Codes]INNER JOIN [Client Demographics]ON [Gender Codes].SEX_M_F=[Client Demographics].Gender)ON [Status Code].Code = [Client Demographics].Status
PIVOT [Gender Codes].Sex;

Question: Can I total the columns(female),(male)and (total) AND display the "Row total" as a percentage of Column total"?

 

[hyperiest]

erich13us, yes you can total the columns and calculate percentages, but you will need to run a select query off of your crosstab query. You can create fields in the select query to calculate your percentages, then use column sums in your report to calculate your totals. Don't forget to force your column headings in your crosstab, or else you won't be able to use the crosstab as a source for the select query.

Hope this helps.

Captain_D