multiple values in crosstab query under column

[MICKI0220]

Is there any way to make a crosstab query show more than one value for a heading across rows. For example. I need a report to look like this

Team Jan Feb Mar Apr May June etc

Blast
Hrs sav 5 6 7 20 30 1 etc
Tm Bonus 10 1 5 10 5 0 etc
Sup Name $ $ $ $ $ $ etc
sup name2 $ $ $ $ $ $ etc


right now I can make it give me the Team bonus field but not the Hrs sav under the correct month. I technically need it to put a total of 4 values under the correct month which include both supervisors bonus. Any help would be greatly appreciated.

 

[dhookom]

Did you check the FAQs of this forum?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]