Display Total Row in Crosstab Query

[zashaikh]

Hello.



I have created a crosstab query that looks as such:



How do I add a row at the bottom that totals the the numbers in the columns so it looks like the image below:



. Below is an image of my CrossTab in design view



Also, I am not sure if this makes a difference, but the "Identification" Field is actually "MinOfIdentification". I had to take the minimun in qryCIv1

Thank you!!!

[ranman256]

you dont.
you can make ANOTHER query on the xtab query to sum the columns. But the nature of Xtab queries keep changing the column headers.
a Report can do it too, but again, youd keep watch and customize it in case the headers change.

[zashaikh]

The headers will always change based on what exactly I enter.

In fact, I what I want to do is create a form or report with fields that will be the criteria for my xtab.

[zashaikh]

I link the form field to the original query. And that works. But when I click on the xtab, I am told that access doesnt recognize [forms]![fieldname]![fieldvalue]