Log in

View Full Version : Dynamic Crosstab Query


JasonChand
Feb 6, 2007, 08:09 PM
I have this payroll database but would like to switch around the row data
Into columns:

Report has

Gross Employe SS Employer SS

Week1
Week2
Week3
Etc for month


I want it like this


Week 1 Week 2 Week 3 Week 4 Week 5

Gross
Employee SS
Employer SS

I will do this report for each month so the columns will remain but data
Must be for the particular month.

Please assist

Thanks

Jason Chand