Question about the crosstab query and a query

[keawee]

Hello,

I would like to ask you several question about the crossTab query.

- I wanted to make a total of my lines of my crosstab query. On the advice of Pat, I have to make a report with in footer, the line for my total. I would like to know this. In my files attached, I have two picures of my two reportings of my crosstab query. - Is it possible to import the line my total my first reporting in the second reporting below the line total?.

- Is it possible to import a query with one only line of recordings (the number of field are the same in my query and my report) in the footer of my principal crosstab query. My objective is to divide each recordings of my first report by the lines of my query. Is what it is possible.

- Is it possible to import my line of total of my report which comes from a crosstab query in a query. Is it possible?

Thank you for your help.

Keawee

 

[keawee]

Hello

Nobody has an idea

Thanks for your help

Keawee

 

[Pat Hartman]

I don't think I understand what you are asking. If you want to add a recap at the end of a detail report, you can do it by placing a subreport in the appropritate footer section.