Cross-Tab, two fields as columns? 1

[GaborH]

Q.1. I am trying to create a cross tab query that has more than one field as column. My goal is to have month and department specific columns. For ex.: Dept.1/March, Dept.2/March, Dept.1./April,.... (the rows contain projects)

I know that department and month fields could be combined into one field to serve as column heading, but I wonder if there is an easier way of doing this.

Q.2. Is it possible to total the above columns on a monthly basis? For example, total all departments for March, April... Or would a separate query be best?

Any hints are highly appreciated!

 

[dhookom]

You might want to take a look at faq701-4524.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[GaborH]

Duane,

Thank you! You are right on target. The example works well.