Two Unrelated Cross-Tabs Used to create report? 1

[woodlandstx]

Is there a way I can take my # of Proposals cross tab and my Value of Proposals cross tab and make them both show up on one report?

Thanks!!!

 

[dhookom]

Sure, you can place them both as subreports on a main report. I assume you are correct in stating they are "unrelated". If they generate the same row heading values, it might be possible to combine them into a single record source for the report.

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

 

[woodlandstx]

Duane -

What would I do without you...lol

I put them both in one form by using them as subforms, but I have never combined anything into a single record source, can you point me in the right direction.

Thanks!!

 

[dhookom]

Combining both crosstabs into a single record source would suggest that either the rows or the columns will relate from one to the other. Since you haven't provided any descriptions of your queries, we can't provide more details.

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