Cross Tab Query Calculation

[NoviceIan]

Hi,

We have a cross tab query which lists different pay bands along the top and
different departments down the side. The value is a calculation of how many
hours each team has of each pay band.

The totals colum calculates how many hours in total each department has. I
was wondering if it would be possible to have a totals row at the bottum as
well so we could see how many hours of each band we have?

Ian

 

[[MVP] S.Clark]

No. Access does not have that ability. But, you can create a 2nd query to
perform the total, then union it with the first to pull it all together.

 

[NoviceIan]

I can create a second query to total the band hours but I dont understand how
I would "union" it. How is that done?

 

[Duane Hookom]

Open Help and search for "union query". If you need more assistance, feel
free to post back.

You can also create column totals in a report.