Cross Tab Query Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
I can create a second query to total the band hours but I dont understand how
I would "union" it. How is that done?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cross Tab Query with two values 1
Prorata calculation - ARRGGHHH! 1
Blank or Null in a Cross Tab Query in Access 2003 2
Help with query calculation 2
DSum in Query 1
Sums & Cross-Tab Query 2
Assigning a banding marker in a query 4
Query set-up not using cross-tab 9

Back
Top