Cross Tab Query with two values

[Brennan]

I have a table with to key fields: Hours Worked and Revenue. I would like to
build a cross tab query that uses each as that value with month as the column
header. How do I put two values into a cross tab query. I can't make
revenue a calculated field because sometimes revenue and hours are not
connected. Thanks

Brennan

 

[Duane Hookom]

There is a solution at http://www.tek-tips.com/faqs.cfm?fid=4524.