help with crosstab report

[dedwards1960]

I have created a crosstab query and have created a report to out put the results. Everything works fine but in need to have a summary of the male and female per each course.

I have attached doc for review if someone can help.

Thanks

 

[genghis82]

Can you post the SQL of your query?
Not too sure how your tables are set up. But if you have males in 1 column and females in another you should be able to create a new field in the query such as :Expr1: [Males]+[Females]

HTH

 

[dedwards1960]

thanks

No both male and female are in one field called gender. I did a crosstab query with rowheaders and colume headers and group by various fields and 1 count field.

Thanks for your help but I figured it out on the report by doing sums of the fields I needed to add together.

I have the number I want and that works for me.