Union with Select and Crosstab Query

[robsant]

Hi,

I am trying to get a report that shows both column totals and row totals.

I have a crosstab query that gives me the Row totals along with the crosstab data.

I have read on a previous post http://www.access-programmers.co.uk/forums/showthread.php?t=195471

That I can union the crosstab to a select query which should get me what I want, but to be honest I am lost. can anyone lead me to an example of code doing this please?

Many thanks,

Rob.

 

[JHB]

Hi,

I am trying to get a report that shows both column totals and row totals.

In a report you can sum each column/control, you don't need an extra query to deliver the result.

 

[robsant]

Great thanks, I used the cross tab to total the rows and a report to total the columns.

 

[JHB]

Exactly - luck with your project.